| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can i set excel 2007 to do a "calculate on open"?
When I open Excel itself - it opens fine.
When I open an excel file - it will not open until I right click and select 'calculate'. Can anyone tell me why? Or How do I set a default "calculate on open"? Thanks SER |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can i set excel 2007 to do a "calculate on open"?
It sounds like you have calculation set to manual. I'm not sure how to
change it in Excel 2007, but if you copy this in the Immediate window of the VBE and press enter, it should also work Application.Calculation = XLCalculationAutomatic -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "SER" wrote: When I open Excel itself - it opens fine. When I open an excel file - it will not open until I right click and select 'calculate'. Can anyone tell me why? Or How do I set a default "calculate on open"? Thanks SER |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can i set excel 2007 to do a "calculate on open"?
Hi,
I'm not positive recalculation mode is your problem since you say everything works OK if you open it from inside of Excel. But you turn on calculation mode in 2007 by choosing Formulas, Calculation Options, Automatic. -- Thanks, Shane Devenshire "SER" wrote: When I open Excel itself - it opens fine. When I open an excel file - it will not open until I right click and select 'calculate'. Can anyone tell me why? Or How do I set a default "calculate on open"? Thanks SER |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Hybrid Mode
