Formula calculation

  • Thread starter Thread starter sierraview
  • Start date Start date
S

sierraview

How do I set a workbook to automatically calculate formulas?
So that the subtotal command will recalculate edited data.
 
Hi,

By default the workbook automatically calculates. It seems that this
feature is set to manual in your workbook. Please set it back to Automatic
in Tools > Options > Calculation

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Excel 2003 workbook not updating values 1
formula recalculation in Excel 2003 - oddity? 3
Forcing to recalculate 7
How to Stop calculation on one specific sheets only 7
IF statement based on need to recalculate 1
sumproduct alternative 1
Subtotal 4
Average of Subtotals in Pivot Table 0

Back
Top