Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PeterM
 
Posts: n/a
Default IS there a way to compare 2 excel files

I like to be able to compare 2 excel files to see how different they are.Is
there such a thing?

  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi

Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
http://www.cpearson.com/excel/download.htm

HTH. Best wishes Harald

"PeterM" skrev i melding
...
I like to be able to compare 2 excel files to see how different they

are.Is
there such a thing?



  #3   Report Post  
pmaston
 
Posts: n/a
Default

Many thanks Harald.......I tell you what my problem is, I have 2 or 3 Excel
files on my pocket pc, that are in native excel document form. I keep
forgetting which file I wrote my last information to. SO I thought if there
was a brilliant person that could write a program, which I would buy, that
would allow me to see the difference, maybe highlighted, between the 2
sheets............I downloaded the item you mentioned, but can not see
anything. I changed my security macro level, to allow the enabling of
macro's and still can't see anything when I ex ecute the file. Any
additional help would be very much appreciated again. I appreciate you a lot
Harald..............Peter

"Harald Staff" wrote in message
...
Hi

Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
http://www.cpearson.com/excel/download.htm

HTH. Best wishes Harald

"PeterM" skrev i melding
...
I like to be able to compare 2 excel files to see how different they

are.Is
there such a thing?




  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

After you load Bill and Myrna's program (and your files),
click on Tools|Compare Worksheets

Another option (maybe)...

Save your files as .csv files.
Then use MSWord to compare the .csv files.



pmaston wrote:

Many thanks Harald.......I tell you what my problem is, I have 2 or 3 Excel
files on my pocket pc, that are in native excel document form. I keep
forgetting which file I wrote my last information to. SO I thought if there
was a brilliant person that could write a program, which I would buy, that
would allow me to see the difference, maybe highlighted, between the 2
sheets............I downloaded the item you mentioned, but can not see
anything. I changed my security macro level, to allow the enabling of
macro's and still can't see anything when I ex ecute the file. Any
additional help would be very much appreciated again. I appreciate you a lot
Harald..............Peter

"Harald Staff" wrote in message
...
Hi

Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
http://www.cpearson.com/excel/download.htm

HTH. Best wishes Harald

"PeterM" skrev i melding
...
I like to be able to compare 2 excel files to see how different they

are.Is
there such a thing?




--

Dave Peterson
  #5   Report Post  
PeterM
 
Posts: n/a
Default

Dave...........many many thanks, this is very much
appreciated...........Peter

"Dave Peterson" wrote in message
...
After you load Bill and Myrna's program (and your files),
click on Tools|Compare Worksheets

Another option (maybe)...

Save your files as .csv files.
Then use MSWord to compare the .csv files.



pmaston wrote:

Many thanks Harald.......I tell you what my problem is, I have 2 or 3
Excel
files on my pocket pc, that are in native excel document form. I keep
forgetting which file I wrote my last information to. SO I thought if
there
was a brilliant person that could write a program, which I would buy,
that
would allow me to see the difference, maybe highlighted, between the 2
sheets............I downloaded the item you mentioned, but can not see
anything. I changed my security macro level, to allow the enabling of
macro's and still can't see anything when I ex ecute the file. Any
additional help would be very much appreciated again. I appreciate you a
lot
Harald..............Peter

"Harald Staff" wrote in message
...
Hi

Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
http://www.cpearson.com/excel/download.htm

HTH. Best wishes Harald

"PeterM" skrev i melding
...
I like to be able to compare 2 excel files to see how different they
are.Is
there such a thing?




--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Downloading Files Using Excel ditane Excel Discussion (Misc queries) 0 March 30th 05 08:55 PM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM
Linking Excel files -- I cannot find an answer anywhere. MAB Excel Discussion (Misc queries) 0 March 28th 05 06:47 PM
Using large excel files Tom Trahan Excel Worksheet Functions 1 January 25th 05 07:35 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"