Geo

From Help on Troubleshooting Merging Workbooks.

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.

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.

........anything there of assistance?


Gord Dibben Excel MVP

On Sat, 19 Nov 2005 12:42:02 -0800, GeoObject
wrote:

receive error message as follows:" Cannot be merged into the current
workbook. Workbooks to be merged must be copies made from the same shared
workbook, and must all maintain the change history for a sufficient amount of
time."

I made copies of all file to be merged but I don't understand change history
is or what is ment by a "sufficient amount of time."