Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-initialising Excel calculation settings
I have an xla that needs to open a workbook when it loads, because of
a previously reported problem: "Excel 2003 graphics are invisible after loading xla". The problem with this is that Excel is no longer in its correct start-up state. In particular, the calculation settings will not then be picked up by the first workbook that a user opens. Does anyone know how to UNSET the calculation settings, so that Excel thinks they haven't been chosen yet? Also, does anyone know of any descriptions of how Excel initialises itself? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-initialising Excel calculation settings
Hi
why not set application.Calculation accordingly (and store the old stte if you want) -- Regards Frank Kabel Frankfurt, Germany "Ant" schrieb im Newsbeitrag m... I have an xla that needs to open a workbook when it loads, because of a previously reported problem: "Excel 2003 graphics are invisible after loading xla". The problem with this is that Excel is no longer in its correct start-up state. In particular, the calculation settings will not then be picked up by the first workbook that a user opens. Does anyone know how to UNSET the calculation settings, so that Excel thinks they haven't been chosen yet? Also, does anyone know of any descriptions of how Excel initialises itself? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-initialising Excel calculation settings
Hi Frank,
Thanks but the problem is that the user will expect the calculation settings to be determined by the first workbook THEY open but it won't be (because I have already opened a file through code).... ....and I can't set the calculation options myself because I don't know what the settings would be in the file they plan to open. The best I can think of is to ask them what settings they want but it might be annoying to do that every time. I was hoping somebody might know how to fool Excel into thinking it hadn't opened any files yet. regards Ant "Frank Kabel" wrote in message ... Hi why not set application.Calculation accordingly (and store the old stte if you want) -- Regards Frank Kabel Frankfurt, Germany "Ant" schrieb im Newsbeitrag m... I have an xla that needs to open a workbook when it loads, because of a previously reported problem: "Excel 2003 graphics are invisible after loading xla". The problem with this is that Excel is no longer in its correct start-up state. In particular, the calculation settings will not then be picked up by the first workbook that a user opens. Does anyone know how to UNSET the calculation settings, so that Excel thinks they haven't been chosen yet? Also, does anyone know of any descriptions of how Excel initialises itself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation Settings changing from automatic to manual | Excel Discussion (Misc queries) | |||
Settings Keep Changing to Manual Calculation | Excel Discussion (Misc queries) | |||
PLEASE SORT OUT THE CALCULATION SETTINGS | Excel Discussion (Misc queries) | |||
Excel settings.... | Setting up and Configuration of Excel | |||
Initialising a variable | Excel Programming |