Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Options
I have a rather large workbook (85 meg) that I've built for a client.
It is necessary that automatic calculation be turned OFF when usin this tool otherwise a normal machine will lock up. Is there a macro o a way to default manual calculation when this workbook is opened? You advice is appreciated -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Options
Place the following line of code in the "Sub Workbook_Open
()" procedure. Application.Calculation = xlManual Michael -----Original Message----- I have a rather large workbook (85 meg) that I've built for a client. It is necessary that automatic calculation be turned OFF when using this tool otherwise a normal machine will lock up. Is there a macro or a way to default manual calculation when this workbook is opened? You advice is appreciated. --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Options
Excel sets its application-level initial calculation mode from the first
workbook opened, and stores the current calculation mode in a workbook when it is saved. So assuming you have saved the workbook in manual mode everything will be ok if it is the first workbook opened. If it is the second workbook opened and Excel is in automatic mode it will be recalculated on open. Any macro contained in the workbook open event will not be executed until after it has opened and calculated: so a complete solution is difficult to achieve. One partial solution is to use a workbook.open macro to set calculation to manual. Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "dmckean" wrote in message ... I have a rather large workbook (85 meg) that I've built for a client. It is necessary that automatic calculation be turned OFF when using this tool otherwise a normal machine will lock up. Is there a macro or a way to default manual calculation when this workbook is opened? You advice is appreciated. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tools options view window options | Excel Discussion (Misc queries) | |||
Calculation options change arbitrarily | Excel Worksheet Functions | |||
Calculation Options | Excel Discussion (Misc queries) | |||
Excel Automatic Calculation Options will not Save | Setting up and Configuration of Excel | |||
default manual calculation instead of auto in options excel 2003 | Excel Discussion (Misc queries) |