formulas correct yet not calculating until reopening file

T

tennille

an excel file is not calculating based on programmed formulas unless i close
the file save it then reopen. only then the formulas calculate
 
N

Norman Jones

Hi Tennille,

Verify that the calculation mode (Tools | Options | Calculation Tab) is set
to Automatic.
 
Top