| 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 |
| 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 | |||
Threaded Mode
