Home

Excel Formulas Not Working Since Year Changed to 2019

Highlighted
Deanea
New 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 stopped 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.