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.