solracesoj
Board Regular
- Joined
- Oct 25, 2002
- Messages
- 144
In Word is so simply to compare two documents!
In Excel, although I’m trying to compare two WORKBOOKS, there is lot’s of difficulties.
In Excel the option “Compare and Merge Documents” is not highlighted.
So when I go to HELP, I see that:
“Requirements for merging Both workbooks must meet the following requirements:
Be copies of the same workbook, which must have been a shared workbook.
Have different file names.
Either not have passwords, or both have the same password.
Have change tracking in effect continuously from when the copies were made.
Keep change history 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.”
So, do I have to fulfill all of this parameters or is there an easier way out?
Thanks in advance
J.C.
In Excel, although I’m trying to compare two WORKBOOKS, there is lot’s of difficulties.
In Excel the option “Compare and Merge Documents” is not highlighted.
So when I go to HELP, I see that:
“Requirements for merging Both workbooks must meet the following requirements:
Be copies of the same workbook, which must have been a shared workbook.
Have different file names.
Either not have passwords, or both have the same password.
Have change tracking in effect continuously from when the copies were made.
Keep change history 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.”
So, do I have to fulfill all of this parameters or is there an easier way out?
Thanks in advance
J.C.