F9 vs. Calculate Sheet

[Guest]

Folks:



I know that I can configure my spreadsheet to manually "re-calculate" by
doing:

TOOLS >> Options >> Calculation Tab >>.

* What is the difference between "Calculate Now(F9) " and "Calculate
Sheet" ?



Thanks,
John.

 

[suro]

F9 (calculate now) will calculate the workbook
while shift+f9 (calculate worksheet) just calculate the worksheet

 

[Guest]

One extra note: suro is right, but if there are too many dependencies then
trying to calculate a range or a sheet will be escalated by Excel to the
workbook. There's an excellent MSDN article about this
here http://msdn2.microsoft.com/en-us/library/aa140058(office.10).aspx

 

[Earl Kiosterud]

John

Ctrl-Alt-F9 is calculate-everything-no-matter-what. It calculates formulas whether their
precedents have changed or not. I spent hours on a complicated record-stuffing macro I was
developing because the totals (in formulas) across the sheets were wrong, and I thought the
records weren't getting in correctly. It turned out that automatic calculation just wasn't
getting it done. Ctrl-Alt-F9 was the only thing that got the correct totals. They're going
to fix this in 2057.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...