I posted this in the Excel forum programming /VBA, but thought I would post it here also:
I am having a strange problem that is occurring on an excel workbook that has quite a bit of VB code in it. The formulas will not calculate. If I go into options, then formulas, Automatic will be on manual. I then check automatic, go back and the formulas still do not update. IF I use the Ctrl, Alt, Shift and F9 keys it will update. Then I close and save the file, come back and the option/formula settings is back at manual again. Other workbooks that I have code in work fine.
Does anyone have any idea what might be going on?
Bookmarks