Hello all. I'm coming up against what seems a rather odd quirk in
Excel, and wondered if anyone could confirm it for me and, ideally,
help me work around it!

I'm working on a large 'output' workbook with a lot of links back to
another workbook. I'm saving backups of the file, and regularly need to
refer to the backups to check what's changed. Opening the 'old' version
with nothing else open gives, as you'd expect, the old numbers. Opening
the 'old' version with the database it links back to gives it the new
numbers, again as you'd expect. However, the problem is that opening
the old and new workbooks together, *without* opening the workbook both
refer to, still updates the 'old' workbook with new numbers! It seems
that it copies the more up-to-date numbers from the new workbook, even
though the master workbook that they're both linked to is closed.

Firstly, is my guess at what's happening correct? And secondly, is
there any way to compare the two workbooks without having to print one
out, close it, open the other one and do it all manually? I also don't
want to value-paste all the different sheets in the old workbook, for
two reasons: I'd like a record of what the formulas should be, and
there is a large number of sheets!

I've looked around the web, and have only found
http://groups.google.com/group/micro...19e7de093a4b4/
which could be a similar issue. Most file-comparison macros seem to
need both worksheets open at once, which I can't do. Any advice?

Thanks in advance,

Ben