compare and merge workbooks
 

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
--
Earl

compare and merge workbooks
 

The compare and merge workbooks is only available when the workbook is
shared under ToolsShare Workbook.

Maybe you were thinking of WindowCompare side by side with when you have
two workbooks open.


Gord Dibben MS Excel MVP


On Sun, 3 Aug 2008 20:35:44 -0700, Earl
wrote:

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

compare and merge workbooks
 

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.
--
Earl


"Gord Dibben" wrote:

The compare and merge workbooks is only available when the workbook is
shared under ToolsShare Workbook.

Maybe you were thinking of WindowCompare side by side with when you have
two workbooks open.


Gord Dibben MS Excel MVP


On Sun, 3 Aug 2008 20:35:44 -0700, Earl
wrote:

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

compare and merge workbooks
 

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


"Earl" wrote:

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.
--
Earl


"Gord Dibben" wrote:

The compare and merge workbooks is only available when the workbook is
shared under ToolsShare Workbook.

Maybe you were thinking of WindowCompare side by side with when you have
two workbooks open.


Gord Dibben MS Excel MVP


On Sun, 3 Aug 2008 20:35:44 -0700, Earl
wrote:

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

compare and merge workbooks
 

See one reply to your other post.


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 07:11:00 -0700, Joanne
wrote:

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


"Earl" wrote:

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.
--
Earl


"Gord Dibben" wrote:

The compare and merge workbooks is only available when the workbook is
shared under ToolsShare Workbook.

Maybe you were thinking of WindowCompare side by side with when you have
two workbooks open.


Gord Dibben MS Excel MVP


On Sun, 3 Aug 2008 20:35:44 -0700, Earl
wrote:

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