![how to merge workbooks in excel 2013 how to merge workbooks in excel 2013](https://i.ytimg.com/vi/ZNTf7X2TrAg/maxresdefault.jpg)
For instance, it can only be used on copies of workbooks saved after making changes to what was previously a shared workbook.
![how to merge workbooks in excel 2013 how to merge workbooks in excel 2013](https://i.ytimg.com/vi/Hx6aFo7okCc/maxresdefault.jpg)
I won't go into much detail about it here because it is usable only under some rather strict conditions. This command is not normally available, but it can be added to the ribbon. It also isn't terribly helpful if the changes in the second workbook may include some inserted or deleted rows or columns.Īnother way you might try is to use what Microsoft calls the Compare and Merge Workbooks command. If the workbooks are simple (meaning, a single worksheet or two) you could copy the worksheets from the second workbook into the first and then add a new worksheet that uses formulas (or formulas in conditional formatting) to compare cells from the duplicate sheets.
![how to merge workbooks in excel 2013 how to merge workbooks in excel 2013](https://support.content.office.net/en-us/media/3286ef6d-051e-4404-b216-57835c922dcb.png)
Checking cells for differences in either values, formulas, or results of formulas can be straightforward, but what about information stored in other objects, such as text boxes, charts, data validation rules, conditional formatting rules, or macros? Do changes in formatting count as a difference? I'm sure you get the idea-defining what constitutes a change can quickly become quite complex and there are numerous other areas where differences could exist, as well. Part of the reason for this complexity is the number of different things that need to be checked when you are determining differences. He wonders if there is a way to compare two workbooks to determine what, exactly, has changed between the two of them.Ĭomparing different workbooks can get a bit tricky and quite complex very quickly. In fact, the second workbook started out as a copy of the first to which new information was added. Ron has two workbooks that are very similar.