Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
I have installed an application software called "Hyperion", after installed
this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Hi May,
I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Hi macropod
We have followed their suggestions to turn off this software, but the problem still exists......what is mean by parameter? How can it be set? Thanks&Regards, May "macropod" wrote: Hi May, I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Hi May,
Well, if "Hyperion" isn't supposed to do this, you'll have to sort it out with the makers. If it is, then you'll have to choose whether you want to continue using it. A parameter is a value you could set to alter the software's behaviour. This would only be relevant if the software is intended to allow you to choose between auto-calc and manual-calc. As a last resort, adding a macro like: Sub Auto_Open() Application.Calculation = xlCalculationAutomatic End Sub to the affected workbook(s) might get around the problem. Cheers -- macropod [MVP - Microsoft Word] "May" wrote in message ... Hi macropod We have followed their suggestions to turn off this software, but the problem still exists......what is mean by parameter? How can it be set? Thanks&Regards, May "macropod" wrote: Hi May, I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Sub Auto_Open << Is "old-tech"
The Current approach is to use the Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic End Sub HTH "macropod" wrote in message : Hi May, Well, if "Hyperion" isn't supposed to do this, you'll have to sort it out with the makers. If it is, then you'll have to choose whether you want to continue using it. A parameter is a value you could set to alter the software's behaviour. This would only be relevant if the software is intended to allow you to choose between auto-calc and manual-calc. As a last resort, adding a macro like: Sub Auto_Open() Application.Calculation = xlCalculationAutomatic End Sub to the affected workbook(s) might get around the problem. Cheers -- macropod [MVP - Microsoft Word] "May" wrote in message ... Hi macropod We have followed their suggestions to turn off this software, but the problem still exists......what is mean by parameter? How can it be set? Thanks&Regards, May "macropod" wrote: Hi May, I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Hi
It is the first Workbook that is opened in any Excel session that sets the calculation mode that Excel uses, until it is subsequently altered by code or manually. It may not be the Hyperion software that has caused a problem, but the setting in the file that now gets opened first. Just check the file that you open first, make sure it has a setting of Automatic calculation, then save it and this might cure the problem. Otherwise, use the code as suggested, but I would put this in Personal.xls, as that is the file that gets opened automatically (and hidden) within Excel, then the calculation mode will be set to Automatic for all your work (until you change it). -- Regards Roger Govier "macropod" wrote in message ... Hi May, Well, if "Hyperion" isn't supposed to do this, you'll have to sort it out with the makers. If it is, then you'll have to choose whether you want to continue using it. A parameter is a value you could set to alter the software's behaviour. This would only be relevant if the software is intended to allow you to choose between auto-calc and manual-calc. As a last resort, adding a macro like: Sub Auto_Open() Application.Calculation = xlCalculationAutomatic End Sub to the affected workbook(s) might get around the problem. Cheers -- macropod [MVP - Microsoft Word] "May" wrote in message ... Hi macropod We have followed their suggestions to turn off this software, but the problem still exists......what is mean by parameter? How can it be set? Thanks&Regards, May "macropod" wrote: Hi May, I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the default manual calculation as automatic
Hi
Thank you. We're using the method of macro. Here, we can turn the software off from the add in as our computer have authorize the admin right now. The automatic calculation seems solved. But is there any other method to solve other than this? Because our IT people said they didn't want to give us the admin right for security reasons. But the macro method is bothering us too much! Anyway, many thanks! May "Roger Govier" wrote: Hi It is the first Workbook that is opened in any Excel session that sets the calculation mode that Excel uses, until it is subsequently altered by code or manually. It may not be the Hyperion software that has caused a problem, but the setting in the file that now gets opened first. Just check the file that you open first, make sure it has a setting of Automatic calculation, then save it and this might cure the problem. Otherwise, use the code as suggested, but I would put this in Personal.xls, as that is the file that gets opened automatically (and hidden) within Excel, then the calculation mode will be set to Automatic for all your work (until you change it). -- Regards Roger Govier "macropod" wrote in message ... Hi May, Well, if "Hyperion" isn't supposed to do this, you'll have to sort it out with the makers. If it is, then you'll have to choose whether you want to continue using it. A parameter is a value you could set to alter the software's behaviour. This would only be relevant if the software is intended to allow you to choose between auto-calc and manual-calc. As a last resort, adding a macro like: Sub Auto_Open() Application.Calculation = xlCalculationAutomatic End Sub to the affected workbook(s) might get around the problem. Cheers -- macropod [MVP - Microsoft Word] "May" wrote in message ... Hi macropod We have followed their suggestions to turn off this software, but the problem still exists......what is mean by parameter? How can it be set? Thanks&Regards, May "macropod" wrote: Hi May, I suggest you ask the people who made "Hyperion". After all, if their software is interacting with Excel, they should know whether you simply need to set a parameter, for example, to control auto-calc. Cheers -- macropod [MVP - Microsoft Word] "May" <May @discussions.microsoft.com wrote in message ... I have installed an application software called "Hyperion", after installed this program, the excel's automatic calculation became manual as default when open files. I need to click "Tools, options, calculation, automatic", then excel can do the calculation automatically. Otherwise, the excel spread sheet is manual calculated. Could you please advise how can I change the default as automatic calculation when I open the files every times? Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change default decimal places? | Excel Discussion (Misc queries) | |||
How do I change the default font color in Excel? | Excel Discussion (Misc queries) | |||
default manual calculation instead of auto in options excel 2003 | Excel Discussion (Misc queries) | |||
why would calculate change from automatic to manual on its own? | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |