Remerging Workbooks

[Guest]

I'm trying to use the "Compare and Merge Workbooks" command for the following
situation:

I've duplicated a "master" file in the same folder and renamed it
say,"Fred". The merge workbooks command works just fine between the two files
for now. Then I emailed the "Fred" file off to another company to make
changes. The file was then emailed back to me and I replaced the original
"Fred" file with the returned one.

The problem I have is that I can no longer use the "Compare and Merge
Workbooks" command.

Is there a way to "remerge" files that have been separated like this?

Thanks!

 

[Saruman]

Sounds like the return file may have the same name as the one you sent out
but it is a copy with the same name.

Normally the compare and merge only works with a shared workbook which
normally has in brackets in the title the word Shared. Excel places markers
in these files to track them. If the return file is not the original, these
markers are missing and you wont be able to merge them as before.

 

[Guest]

Thanks Saruman...

Darn

Sounds like the return file may have the same name as the one you sent out
but it is a copy with the same name.

Normally the compare and merge only works with a shared workbook which
normally has in brackets in the title the word Shared. Excel places markers
in these files to track them. If the return file is not the original, these
markers are missing and you wont be able to merge them as before.