I'm struggling to merge two workbooks in XL. I've names and addresses on two workbooks, one is more up to date than the other but not all has changed. When I follow the instuctions in HELP on Excel, it tells me to click on TOOLS then "Compare & Merge workbooks" but that option is graeyed out. Can anyone help please
The workbooks are NOW shared,and saved in a folder in my desktop. However, when I try to merge, a dialogue box pops up, and tells me that Excel could not merge the 2 workbooks, and also the changes must be saved for a reasonable time ??
I've shared the 2 workbooks I want to merge, and saved them to a folder on my desktop. I've even made copies of them nad give them a different name, from the originals. When they are shared the option under TOOLS is no longer greyed out, but when I click on this option it says the workbook will be saved. Then when I click TOOLS > COMPARE & MERGE WORKBOOKS, a dailogue box pops up saying:-
" Cannot be merged into the current workbook.Workbooks must be copies made from the same shared workbook, And must maintain the change history for a sufficient amount of time"
Troubleshoot merging workbooks Show All Hide All The workbooks I want to combine won't merge.
Requirements for merging
Both workbooks must meet the following requirements:
Be copies of the same workbook, which must have been a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.).
Have different file names.
Either not have passwords (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), or both have the same password.
Have change tracking in effect continuously from when the copies were made.
Keep change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) back at least as far as the date when the copies were made. For example, if the change history is being kept in the workbooks for 30 days, and the copies were made 45 days ago, you can no longer merge the workbooks.
Plan ahead for later merging When you turn on change tracking but aren't sure when you'll merge the workbooks, set a large number of days for the history, up to the maximum of 32,767 days.
Merge changes manually If the workbooks still won't merge, you can incorporate the information from one workbook into another manually, by copying and pasting from one workbook to another.