| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I set the default recalculate option to automatic?
ans there any way that I cna set a default option so that "automatic
recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
This is an application setting. ToolsOptionsCalculation..
If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
Jacob
I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
In 2007, click the Office Button, then Excel Options and Formulas.
If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Jacob I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
Thanks Jacob.
But that only sets it for that Workbook. I want to be able to set automatic calculation as the default option for all workbooks at once. Neil "Jacob Skaria" wrote: In 2007, click the Office Button, then Excel Options and Formulas. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Jacob I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
Excel uses the calculation mode of the first workbook opened.
Doesn't matter if subsequent workbooks were save in auto mode if the first one is in manual mode. Workaround is to have your Personal.xlsb saved in auto mode which will set the mode for subsequent opened workbooks. Or just any hidden workbook in XLSTART folder will do. Gord Dibben MS Excel MVP On Fri, 12 Jun 2009 09:13:01 -0700, Neil wrote: Thanks Jacob. But that only sets it for that Workbook. I want to be able to set automatic calculation as the default option for all workbooks at once. Neil "Jacob Skaria" wrote: In 2007, click the Office Button, then Excel Options and Formulas. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Jacob I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
Hello Gord
Sounds interesting workaround - but not sure I understand about "personal.xlsb" or "any hidden workbook in XLSTART folder". Please could you explain how I do both of these? Thanks "Gord Dibben" wrote: Excel uses the calculation mode of the first workbook opened. Doesn't matter if subsequent workbooks were save in auto mode if the first one is in manual mode. Workaround is to have your Personal.xlsb saved in auto mode which will set the mode for subsequent opened workbooks. Or just any hidden workbook in XLSTART folder will do. Gord Dibben MS Excel MVP On Fri, 12 Jun 2009 09:13:01 -0700, Neil wrote: Thanks Jacob. But that only sets it for that Workbook. I want to be able to set automatic calculation as the default option for all workbooks at once. Neil "Jacob Skaria" wrote: In 2007, click the Office Button, then Excel Options and Formulas. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Jacob I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I set the default recalculate option to automatic?
I must say that I find this all rather starnge. I would have thought that
being able to change a global setting for how Excel calculates workbooks (between automatic or manual) via the Office button and the settings tab, would have not been that complicated and indeed very useful (rather than just being able to change it for each individual workbook). Maybe M/S could look at including this in future upgrades? "Gord Dibben" wrote: Excel uses the calculation mode of the first workbook opened. Doesn't matter if subsequent workbooks were save in auto mode if the first one is in manual mode. Workaround is to have your Personal.xlsb saved in auto mode which will set the mode for subsequent opened workbooks. Or just any hidden workbook in XLSTART folder will do. Gord Dibben MS Excel MVP On Fri, 12 Jun 2009 09:13:01 -0700, Neil wrote: Thanks Jacob. But that only sets it for that Workbook. I want to be able to set automatic calculation as the default option for all workbooks at once. Neil "Jacob Skaria" wrote: In 2007, click the Office Button, then Excel Options and Formulas. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: Jacob I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there. That is the problem - nowhere to set universal defaul options. Neil "Jacob Skaria" wrote: This is an application setting. ToolsOptionsCalculation.. If this post helps click Yes --------------- Jacob Skaria "Neil" wrote: ans there any way that I cna set a default option so that "automatic recalculate" becomes the default for all worksheets, old and new? It seems silly that you have to open a worksheet saved with the automatic recalculation option in it for other worksheets to be that way. There is no way i can remember how I saved each and every spreadsheet I have used over the last 10 years!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic backup option | Excel Discussion (Misc queries) | |||
| Change default chart option in registry | Charts and Charting in Excel | |||
| How do I set the default paste option? | Setting up and Configuration of Excel | |||
| W Exp needs easier option for DEFAULT Explorer Bar ie "Folders" | Excel Discussion (Misc queries) | |||
| How do I set the Default Paste Option | Setting up and Configuration of Excel | |||
Linear Mode
