Arlen Kemer
Guest
Joined: 12 Apr 2005
Posts: 23
|
| Posted: Mon Apr 18, 2005 2:22 pm Post subject: Re: I would like to compare large Excel files with calculati |
|
|
Alan wrote: Hello,
I have some large files in Excel that I want to compare. The files have many sheets and lots of calculation (formulas). Actually these files are part of a big report. I would like to check if there are any difference in data and calculation methods. So my question is: can Compare Suite compare large Excel files and display all the differences if any?
Thank you.
Thank you for the question. During file comparison operation Compare Suite converts Excel file to a text file. And then the program immediately compares 2 text files. So if the text and the result of calculations (formulas) are different the program will display it and highlight the text that is different. But if the result of calculations in 2 files is the same but formulas are different the program considers such texts to be identical. For example in 2 files in 2 different formulas: =10/2 and = 25-20 the result is the same (in the result cell you will have 5). So the program treats texts as identical. |
|
