Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.17 Why doesn't my spreadsheet recalculate? (spreadsheets: Excel)

Microsoft Excel has been notorious for not recalculating
automatically, the last few releases. this is scary.

see http://support.microsoft.com/support/kb/articles/q174/8/68.asp
see ftp://ftp.microsoft.com/deskapps/excel/kb/q174/8/

to force a recalc (perhaps after every formula or data change!),
type Ctrl+Alt+F9, or `Application.SendKeys "^%{F9}"' in VBA.

a search-and-replace of `=' with `=' will also force recalculation
(which might be required after a Copy and Paste).

 

Continue to:

• prev: 10.15.1 How can I get a list of names defined in a spreadsheet in a form I can search for, print, compare with others, etc.? (spreadsheets: Excel)
• Index
• next: 10.17.1 Why do my User-Defined Functions return #VALUE! occasionally? (spreadsheets: Excel)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro