Forum Discussion
Result of formula is diferent when I open the file with excel and when I review the xml
Hi
I have a file in excel in which the result of the formula is different when I open the file with excel and when I see the xml definition (In other words I open the zip file of the xmlsm) since the file is a group of xml files.
For instance in the sheet: FC_FINANCIERO, I have a value: 3567.64 but in the sheet 7 of the group of xml I see the value: 3528.22.
The file is: https://drive.google.com/open?id=1JHdEnNengIx-TCie9ZCjuu6DFmXanKjm
The incorrect value is the red: https://social.technet.microsoft.com/Forums/getfile/1282453
The value that I see in sheet7.xml is:
- JKPieterseSilver ContributorThis is because the file has not been calculated just before saving or because something has changed since the save (for example due to a TODAY function changing the date).
- juan maximiliano aguilar abantoCopper Contributor
Hi
In the first case: This is because the file has not been calculated just before saving. Book calculation is in mode: "Automatic".
In the second case: because something has changed since the save (for example due to a TODAY function changing the date). All the cells are numbers.
Don't forget the file is:
https://drive.google.com/open?id=1JHdEnNengIx-TCie9ZCjuu6DFmXanKjm
- JKPieterseSilver Contributor
Whatever the reason is, hundreds of cells in your file change after pressing F9 when it has been opened, not just the one you pointed out. Apparently the file has not been properly calculated the last time it has been saved.
There probably is a tool called Spreadsheet Compare on your system which you can use to compare the original file (not calculated) with a copy which you have calculated. It will tell you which cells have different values.