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.

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

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/lib...ffice.10).aspx



--
http://www.alignment-systems.com


"suro" wrote:

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

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...
-----------------------------------------------------------------------
<JoJo wrote in message ...
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.