| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off autocalc
I have a module that loops an open several hunderd other excel dat files. Although I used the command Application.Calculation = xlCalculationManual it is still calculating eachtime one of these files is opened. I there someting I can write in the module that will not allow th calcualting (which seriously slows down the subroutine. Thank -- barrfl Excel User - Energy market ----------------------------------------------------------------------- barrfly's Profile: http://www.excelforum.com/member.php...nfo&userid=414 View this thread: http://www.excelforum.com/showthread.php?threadid=37689 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off Autocalc before opening sheet | Excel Discussion (Misc queries) | |||
| AutoCalc | Excel Discussion (Misc queries) | |||
| Links not updating - autocalc is on | Excel Discussion (Misc queries) | |||
| autocalc to complicated to turn off | Setting up and Configuration of Excel | |||
| links not updating although autocalc is On? | Excel Discussion (Misc queries) | |||
![barrfly[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
