F9 vs. Calculate Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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...
 
Back
Top