Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
F9 vs. Calculate Sheet
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. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
F9 vs. Calculate Sheet
F9 (calculate now) will calculate the workbook
while shift+f9 (calculate worksheet) just calculate the worksheet |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
F9 vs. Calculate Sheet
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
F9 vs. Calculate Sheet
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F9 vs. Calculate Sheet | Excel Discussion (Misc queries) | |||
How to Calculate ANTILOG in EXCEL SHEET? | Excel Worksheet Functions | |||
Calculate at the bottom of the sheet? | Excel Discussion (Misc queries) | |||
formula to calculate a time sheet | Excel Worksheet Functions | |||
formula to calculate a time sheet | Excel Worksheet Functions |