How to Merge Workbooks in Excel 2003
If several people are making changes to an Excel workbook, you may want to merge all the copies back into one master copy. Learn how to merge workbooks in Excel 2003.
Other People Are Reading
Instructions
-
-
1
Create a shared workbook by enabling the Track Changes option. Then send it out to others to make changes.
-
2
Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
-
-
3
Click "Tools > Compare" and "Merge Workbooks."
-
4
Look for the files you want to merge and add them into the current file.
-
5
Click "OK" to merge the files. This is your master copy of this workbook.
-
6
Save the file.
-
1
Tips & Warnings
Save frequently to prevent lost work.
To add multiple files at once, hold down the "Ctrl" key while clicking on the files you'd like to add. You can also the "Shift" key and click on files to add multiple files from the same folder.
More Like This
Comments
-
macgenius
Dec 11, 2009
On the other hand, if you have multiple workbooks and you simply need to merge the data vertically into one master file, you can try bulk file merger to do this task. You don't need any macro programming knowledge, just hit the merge button. I merged over 240 files in seconds. -
mryanaz
Sep 23, 2008
Have you looked at Distributed Spreadsheet. It will solve the problem going forward. Currently, if you did not flag the workbook as shared prior to supplying copies to the remote offices, the Excel Merge funciton will not work. That puts you into finding VBA code that will copy the cells. There are a number of VBA wizards around who probaly have code pieces they will supply you. I'd start with Chip Pearson and his web site.
-
marksloan
May 16, 2007
When I try to do this with 3 workbooks, all of which are exactly the same, all I get are the results for one workbook. What I am trying to do is merge the values of three workbooks for financial information coming in from three offices. Does anybody know what I may be doing wrong?
