IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
Undo results of the Bulk Merge operation
In the previous topic we've described Bulk Merge operations. This is very important operation, but without Undo it became dangerouns. One click and you should close workbooks without saving and re-compare them again. So, we've implemented both operations in the same update - Bulk Merge and Bulk Undo.
Bulk Merge operations are represented by 2 toolbar commands and Popup menu in the Right Click Menu (RCM) in the Difference Explorer. Bulk Undo commands are in the RCM only:
To undo results of the bulk operation, use RCM | Bulk Merge | UNDO all merge commands in the ... book command.
You can use this command not only in context of the Bulk Merge operation. This is separate command. You can use it to undo all modifications you've done on the specific worksheet, VBA Module, VBA Form. Or in the whole workbook.