Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate at the bottom of the sheet?
On one of my files at work, the word "Calculate" appears at the bottom of the
page about a 1/3 of the way next to "Ready." It is only on one file. What does this mean? Is this something that is going to effect how the different sheets are calculated? Thanks |
#2
|
|||
|
|||
The autocalculation function has most likely been set to calculate manually. This is an option that you can change in the tools - options- calcualtion tab. If it a large file and takes a long time to calculate, or if it is your preference to keep in as a manual calc file, simply press the F9 key to manually calculate the workbook, or press shift F9 to manually calculate the avtiveworksheet. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=392484 |
#3
|
|||
|
|||
If excel is set for manual calculation (tools|Options|calculation tab), and
you've made a change to the worksheet, then excel warns you to recalculate before you trust the displayed values. But there are some cases when calculate appears even when the calc mode is set to automatic. This is from a KB article: http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References ....After the workbook has passed this limit, Excel no longer attempts to recalculate only changed cells. Instead, it recalculates all cells after each change. This behavior is by design of Microsoft Excel. Microsoft Excel will correctly calculate all formulas. ... AndyAnalyst wrote: On one of my files at work, the word "Calculate" appears at the bottom of the page about a 1/3 of the way next to "Ready." It is only on one file. What does this mean? Is this something that is going to effect how the different sheets are calculated? Thanks -- Dave Peterson |
#4
|
|||
|
|||
Thanks Dave, that was exactly what I was looking for.
"Dave Peterson" wrote: If excel is set for manual calculation (tools|Options|calculation tab), and you've made a change to the worksheet, then excel warns you to recalculate before you trust the displayed values. But there are some cases when calculate appears even when the calc mode is set to automatic. This is from a KB article: http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References ....After the workbook has passed this limit, Excel no longer attempts to recalculate only changed cells. Instead, it recalculates all cells after each change. This behavior is by design of Microsoft Excel. Microsoft Excel will correctly calculate all formulas. ... AndyAnalyst wrote: On one of my files at work, the word "Calculate" appears at the bottom of the page about a 1/3 of the way next to "Ready." It is only on one file. What does this mean? Is this something that is going to effect how the different sheets are calculated? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
linking values from one sheet to another | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |