Forum Discussion

juan maximiliano aguilar abanto's avatar
Jun 18, 2018

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: 

 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    This 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).
      • JKPieterse's avatar
        JKPieterse
        Silver 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.

Resources