Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate keeps appearing while on automatic
hello,
I have a really bugging thing that keeps happening to me. On a specific workbook, the word "calculate" appears at the bottom of the page. However the option is on automatic and even after I recalculate (F9) it is still there. I have tried with the following VBA when opening the workbook, but nothing works. Any idea? With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False Calculate Thanks -- caroline |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate keeps appearing while on automatic
Hi Caroline,
Look he http://www.decisionmodels.com/calcsecretsf.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "caroline" wrote in message ... hello, I have a really bugging thing that keeps happening to me. On a specific workbook, the word "calculate" appears at the bottom of the page. However the option is on automatic and even after I recalculate (F9) it is still there. I have tried with the following VBA when opening the workbook, but nothing works. Any idea? With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False Calculate Thanks -- caroline |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate keeps appearing while on automatic
caroline;242526 Wrote: hello, I have a really bugging thing that keeps happening to me. On a specific workbook, the word "calculate" appears at the bottom of the page. However the option is on automatic and even after I recalculate (F9) it is still there. I have tried with the following VBA when opening the workbook, but nothing works. Any idea? With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False Calculate Thanks -- caroline Hello caroline, The message appears on the Status Bar. You can hide it with the following code... Application.DisplayStatusBar = False -- Leith Ross Sincerely, Leith Ross 'The Code Cage' (http://www.thecodecage.com/) ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67620 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate keeps appearing while on automatic
Thanks a million. This link gave me the answer:
I hit one of Excels limits for tracking dependencies. -- caroline "Niek Otten" wrote: Hi Caroline, Look he http://www.decisionmodels.com/calcsecretsf.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "caroline" wrote in message ... hello, I have a really bugging thing that keeps happening to me. On a specific workbook, the word "calculate" appears at the bottom of the page. However the option is on automatic and even after I recalculate (F9) it is still there. I have tried with the following VBA when opening the workbook, but nothing works. Any idea? With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False Calculate Thanks -- caroline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove automatic calculate function? | Excel Discussion (Misc queries) | |||
Name field - automatic calculate | Excel Discussion (Misc queries) | |||
why would calculate change from automatic to manual on its own? | Excel Discussion (Misc queries) | |||
Calculate won't go away despite being on Automatic | Excel Discussion (Misc queries) | |||
Automatic Calculate Worksheets | Excel Worksheet Functions |