formulas correct yet not calculating until reopening file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Verify that the calculation mode (Tools | Options | Calculation Tab) is set
to Automatic.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula doesn't work unless hit enter again 5
AutoCalc in Excel is stuck! 2
Recalculation does not work 8
how to calculate hrs flown in last one year 0
Excel not calculating formulas 3
Run numerous calculations through a single formula 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
I have a message "calculate" - how to resolve this issue ? 5

Back
Top