Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
The Calculation mode setting is an Application level setting stored in each saved workbook, and so Excel only has a single setting for all the workbooks that are open.
Excel takes the initial setting from the first workbook opened, so you must be opening a workbook with a manual setting regularly, or perhaps it is in your XLSTART folder, or perhaps your personal.xls is set to manual, or perhaps any templates you use??
Regards
Ken...............
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
Ken - question on this - do you not find it weird that in Tools>Options, there are application level options (calc), Workbook level options and sheet level options and no real way of determining which is which....
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Thanks that worked a treat. Open personal.xls changed to autocalc settings in the tools/options. closed and saved settings. Opened spreadsheet no problems.
It's your personal macro workbook. If you have never recorded a macro then you probably don't have one yet. Excel gives you the opportunity to store macros in a special hidden workbook that will open automatically in the background every time you launch Excel. Any macros stored in this workbook are automatically available for you to use on any other workbook you are working on.
If you hit Tools/ Macro / Record Macro and then use the dropdown arrow to choose 'store in my personal macro workbook', and then type a 1 in any cell and then either hit the stop button or hit Tools / Macro / Stop Recording, you will now have created a personal.xls
You can access this file at any time from the VBE (Visual Basic Editor) by hitting ALT+F11 and looking for the file marked PERSONAL in the tree like view top left on your screen. You can also unhide it using Window / Unhide, but don't forget to hide it again afterwards.
I have hundreds of little routines that make my life a hell of a lot easier, and they are all stored in this workbook. Eveery time I come across a useful routine that someone else posts that may be useful to me, I simply add it to my personal.xls. these routines are then all available via Tools / macro etc, or for the most common ones I use I will assign keyboard shortcuts to them by using Tools / Macro / Macros, clicking on the routine in question, hitting the options button on the dialog box and then putting in the keyboard combo I wish to use to initiate that routine.
Anytime you change your personal.xls and then close Excel you may well be prompted to save changes. If you do not do this then any changes such as keybopard combos etc will be lost.
Regards
Ken...........
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.