10.17 Why doesn't my spreadsheet recalculate? (spreadsheets: Excel)
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:
My Books
