compare and merge workbooks

[Earl]

Using Excell 2003 program stops responding saves file then recovers the file
but it is about half the original size. Under tools I would like to use the
compare and merge function to compare the original with the recoverd file but
it is greyed out. Any help would be great. Also is Excell compressing the
file or am I losing data. Thanks

 

[Gord Dibben]

The compare and merge workbooks is only available when the workbook is
shared under Tools>Share Workbook.

Maybe you were thinking of Window>Compare side by side with when you have
two workbooks open.


Gord Dibben MS Excel MVP

 

[Earl]

Thank you very much for the help. The compare and merge function does not
appear to do what I had hoped it would. What I wanted to do was compare two
different spreadsheets that should contain identical data and have any
differences noted or highlighted. Thanks again.

 

[Joanne]

Earl, that's what I want to do. How do I compare 2 Excel workbooks (same
layout, etc) automatically? Did you find your answer?

 

[Gord Dibben]

See one reply to your other post.


Gord Dibben MS Excel MVP