Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compare two versions of an excel document?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compare two versions of an excel document?
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. fiona wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing two different versions of the same document | Excel Discussion (Misc queries) | |||
greyed out compare and merge document | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
My excel document is opening two versions. | Excel Worksheet Functions | |||
Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) |