How do I compare two versions of an excel document?

F

fiona

I have been given an updated version of a spreadsheet and I have the original
on my computer can I compare the two so I can see what has been changed
without going through line by line
 
D

Dave Peterson

It depends on what you're looking for.

This may help if you want to compare two worksheets and do a cell by cell
comparison (A1 with A1, x99 with x99, ...)

http://www.cpearson.com/excel/whatsnew.aspx
look for compare.xla

======
But as soon as a row/column is inserted or deleted, then the results go to heck.

If you're only looking at values in two worksheets, you may be able to save the
worksheets as comma separated and then use another program to compare these two
..CSV files.

MSWord has this ability. And there are free versions of file comparisons that
you can find via google.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top