Excel Formulas not working since year changed to 2019

Copper Contributor

Excel formulas in every worksheet stopped working on 1/1/19.  These are financial spread sheets that are set up to calculate debits and credits, as in a checkbook.  A Check writing spreadsheet that is set up to write out an amount in words once the numeric field is complete has also stoppged working.  I did notice that if I save the document the fields automatically correct themselves, but I don't always remember to do a save to correct the spreadsheet.  The errors have caused big headaches for the last two weeks.  Any help would be appreciated.

 

Update:  problem resolved.  Formula option set on manual, has now been reset to automatic.

3 Replies
Hi!
Make sure to post this in the excel forum as well!

Adam

Thank you Mark.  I will be sure to do that once I figure out how.

Sorry Adam.  I was a little preoccupied.