formulas correct yet not calculating until reopening file

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
 
N

Norman Jones

Hi Tennille,

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

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

Formulas aren't calculating 2
Calculating cells 1
Calculate Selected Cells Only? 3
Formulas not copying to other cells 10
Display message while calculating forumlas 3
Formulas not calculating - Calculation is on Automatic & I pressed 2
Basic Formulas not calculating 3
Calculating: (1 Processor(s)): 25% MESSAGE ON STATUS BAR 2

Top