Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation appear on status bar when in autocalc mode
I can't get rid of the Calculation appearing on the bottom left of my screen
- status bar. Tools - Options - Calculations: set to Automatic. File size 2.9 MB, comprised of 15 worksheets with a total formula count of just under 20,000 functions (mostly =dsum()). Use F9 as well as CTRL-Alt-F9 on each sheet to no avail to get rid of the CALCULATION showing on the status bar. Only when I delete the worksheet containing the Data-ImportExternalDate-Imported data from another worksheet (no formula on this worksheet) does the word 'Calculation' go away. Imported data 156 columns x 1,200 rows (no calculated data, just values). Running Office 2003 with SPK 3. Any suggestions would be greatly appreciated. I need to run in office 2003 for a while longer - I'm sure the Calculation message would not appear in Excel 2007. Thank you in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation appear on status bar when in autocalc mode
It is probably caused by exceeding the number of dependent cells
within the dependency table (64k). See here for a more detailed explanation: http://www.decisionmodels.com/calcsecretsf.htm Hope this helps. Pete On Oct 19, 11:38 pm, RiverGully wrote: I can't get rid of the Calculation appearing on the bottom left of my screen - status bar. Tools - Options - Calculations: set to Automatic. File size 2.9 MB, comprised of 15 worksheets with a total formula count of just under 20,000 functions (mostly =dsum()). Use F9 as well as CTRL-Alt-F9 on each sheet to no avail to get rid of the CALCULATION showing on the status bar. Only when I delete the worksheet containing the Data-ImportExternalDate-Imported data from another worksheet (no formula on this worksheet) does the word 'Calculation' go away. Imported data 156 columns x 1,200 rows (no calculated data, just values). Running Office 2003 with SPK 3. Any suggestions would be greatly appreciated. I need to run in office 2003 for a while longer - I'm sure the Calculation message would not appear in Excel 2007. Thank you in advance for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation appear on status bar when in autocalc mode
Maybe...
http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References RiverGully wrote: I can't get rid of the Calculation appearing on the bottom left of my screen - status bar. Tools - Options - Calculations: set to Automatic. File size 2.9 MB, comprised of 15 worksheets with a total formula count of just under 20,000 functions (mostly =dsum()). Use F9 as well as CTRL-Alt-F9 on each sheet to no avail to get rid of the CALCULATION showing on the status bar. Only when I delete the worksheet containing the Data-ImportExternalDate-Imported data from another worksheet (no formula on this worksheet) does the word 'Calculation' go away. Imported data 156 columns x 1,200 rows (no calculated data, just values). Running Office 2003 with SPK 3. Any suggestions would be greatly appreciated. I need to run in office 2003 for a while longer - I'm sure the Calculation message would not appear in Excel 2007. Thank you in advance for your help. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation appear on status bar when in autocalc mode
Thank you. The issue does seem with the data linked information (data link)
- just too big. "Pete_UK" wrote: It is probably caused by exceeding the number of dependent cells within the dependency table (64k). See here for a more detailed explanation: http://www.decisionmodels.com/calcsecretsf.htm Hope this helps. Pete On Oct 19, 11:38 pm, RiverGully wrote: I can't get rid of the Calculation appearing on the bottom left of my screen - status bar. Tools - Options - Calculations: set to Automatic. File size 2.9 MB, comprised of 15 worksheets with a total formula count of just under 20,000 functions (mostly =dsum()). Use F9 as well as CTRL-Alt-F9 on each sheet to no avail to get rid of the CALCULATION showing on the status bar. Only when I delete the worksheet containing the Data-ImportExternalDate-Imported data from another worksheet (no formula on this worksheet) does the word 'Calculation' go away. Imported data 156 columns x 1,200 rows (no calculated data, just values). Running Office 2003 with SPK 3. Any suggestions would be greatly appreciated. I need to run in office 2003 for a while longer - I'm sure the Calculation message would not appear in Excel 2007. Thank you in advance for your help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation appear on status bar when in autocalc mode
Thank you. Very good link.
"Dave Peterson" wrote: Maybe... http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References RiverGully wrote: I can't get rid of the Calculation appearing on the bottom left of my screen - status bar. Tools - Options - Calculations: set to Automatic. File size 2.9 MB, comprised of 15 worksheets with a total formula count of just under 20,000 functions (mostly =dsum()). Use F9 as well as CTRL-Alt-F9 on each sheet to no avail to get rid of the CALCULATION showing on the status bar. Only when I delete the worksheet containing the Data-ImportExternalDate-Imported data from another worksheet (no formula on this worksheet) does the word 'Calculation' go away. Imported data 156 columns x 1,200 rows (no calculated data, just values). Running Office 2003 with SPK 3. Any suggestions would be greatly appreciated. I need to run in office 2003 for a while longer - I'm sure the Calculation message would not appear in Excel 2007. Thank you in advance for your help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When in filter mode status bar doesn't show range of cells filted | Excel Worksheet Functions | |||
STATUS BAR LENGHT OF CALCULATION BOX | Excel Discussion (Misc queries) | |||
Status bar does not display filter mode | Excel Discussion (Misc queries) | |||
How do I stop Filter Mode from appearing in the status bar | Excel Discussion (Misc queries) | |||
status bar shows "filter mode" | Excel Worksheet Functions |