Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare And Merge Workbooks | Excel Worksheet Functions | |||
Compare and Merge Workbooks | Excel Worksheet Functions | |||
Compare & Merge Workbooks | Excel Discussion (Misc queries) | |||
URGENT - Merge/compare workbooks | Excel Discussion (Misc queries) | |||
compare and merge workbooks | Excel Worksheet Functions |