Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Manual vs Automatic
My computer switches in the Tools -- Options menu and then the calculation
tab from automatic to manual by itself. I will select automatic one day and the next day I will be working in Excel and suddenly it has switched to manual again. What can I do so that it remains on Automatic since I am not changing it? It's really annoying because sometimes I don't think about it since I didn't switch it to begin with. Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Manual vs Automatic
You must be opening a workbook that has been set to manual, that will
change it. Check the settings on the files you have opened. TJAC wrote: My computer switches in the Tools -- Options menu and then the calculation tab from automatic to manual by itself. I will select automatic one day and the next day I will be working in Excel and suddenly it has switched to manual again. What can I do so that it remains on Automatic since I am not changing it? It's really annoying because sometimes I don't think about it since I didn't switch it to begin with. Thanks for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Manual vs Automatic
Excel picks up this setting from the first workbook you open in that session.
If you have a workbook that is shared between lots of folks, maybe one of them opened, changed that setting and then saved the workbook. TJAC wrote: My computer switches in the Tools -- Options menu and then the calculation tab from automatic to manual by itself. I will select automatic one day and the next day I will be working in Excel and suddenly it has switched to manual again. What can I do so that it remains on Automatic since I am not changing it? It's really annoying because sometimes I don't think about it since I didn't switch it to begin with. Thanks for your help! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Manual vs Automatic
If you wanted a VBA solution, this code would go in the ThisWorkbook module
of your personal.xls workbook. Private WithEvents XLApp As Excel.Application Private Sub Workbook_Open() Set XLApp = Excel.Application End Sub Private Sub XLApp_NewWorkbook(ByVal Wb As Workbook) XLApp.Calculation = xlCalculationAutomatic End Sub Private Sub XLApp_WorkbookOpen(ByVal Wb As Workbook) XLApp.Calculation = xlCalculationAutomatic End Sub HTH, JP "TJAC" wrote: My computer switches in the Tools -- Options menu and then the calculation tab from automatic to manual by itself. I will select automatic one day and the next day I will be working in Excel and suddenly it has switched to manual again. What can I do so that it remains on Automatic since I am not changing it? It's really annoying because sometimes I don't think about it since I didn't switch it to begin with. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation - Automatic and Manual | Excel Discussion (Misc queries) | |||
automatic and manual calculation not working | Excel Worksheet Functions | |||
Automatic/Manual Calculation | New Users to Excel | |||
Automatic Calculation switching to manual | Excel Discussion (Misc queries) | |||
Manual / Automatic Calculation | Excel Discussion (Misc queries) |