Excel is not re-calculating when I hit F9 key!

Problem

We're in the situation where the spreadsheet in which we use NumXL for seasonal adjustment isn't calculating. The file is set to manual calculation, so I hit F9 to trigger re-calculation,  they all return #N/A's.

The spreadsheet file contains tens-to-hundreds of time-series models, and they worked perfectly before, but suddenly this issue pops up.

Furthermore, If I copy any of the time series data-set and its models to a new workbook file, the models work fine in that file. 

Resolution

Save the workbook file to a new file  (File -> Save As), close the workbook, and open the new workbook file.  This should take care of the problem.  

Comments

  • We believe that the Excel workbook file is getting corrupted, but saving it to a new file remedies any inconsistency found in the workbook.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful