(Msg. 1) Posted: Sun Aug 03, 2008 8:35 pm
Post subject: compare and merge workbooks Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
(Msg. 2) Posted: Mon Aug 04, 2008 2:44 pm
Post subject: Re: compare and merge workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
On Sun, 3 Aug 2008 20:35:44 -0700, Earl <Earl.DeleteThis@discussions.microsoft.com>
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
(Msg. 3) Posted: Wed Aug 06, 2008 4:52 pm
Post subject: Re: compare and merge workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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 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
>
>
> On Sun, 3 Aug 2008 20:35:44 -0700, Earl <Earl.DeleteThis@discussions.microsoft.com>
> 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
>
>
(Msg. 4) Posted: Tue Aug 12, 2008 7:11 am
Post subject: Re: compare and merge workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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 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
> >
> >
> > On Sun, 3 Aug 2008 20:35:44 -0700, Earl <Earl.DeleteThis@discussions.microsoft.com>
> > 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
> >
> >
(Msg. 5) Posted: Tue Aug 12, 2008 10:33 am
Post subject: Re: compare and merge workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
See one reply to your other post.
Gord Dibben MS Excel MVP
On Tue, 12 Aug 2008 07:11:00 -0700, Joanne
<Joanne DeleteThis @discussions.microsoft.com> 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 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
>> >
>> >
>> > On Sun, 3 Aug 2008 20:35:44 -0700, Earl <Earl DeleteThis @discussions.microsoft.com>
>> > 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
>> >
>> >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office