Merge Copies Of Shared Workbook. Click the Tools menu and then select Merge Workbooks. Open the shared workbook you want to merge changes and click arrow of the Customize Quick Access Toolbar then select More Commands.
Click File Save. Now select all the files you want to merge and all worksheets of these Excel files will be copied to the current workbook. Make sure the copies of the shared workbook that you want to merge are all stored in the same folder.
Share your Excel file to a local network location.
Any idea what this error means. Share your Excel file to a local network location. If prompted save the workbook. Merging copies of a shared workbook.