LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,090
Default Excel sets calculation to Manual automatically

Excel 2002, 2003, WinXP
An OP I am helping has Excel 2003. I have 2002.
I wrote a good bit of code for him in a file called Bens.xls that resides in
his XLSTART folder.
I have almost the same file in my XLSTART folder.
That file has nothing but code and is about 400 KB big.
I'll call my file MyBens.xls and his HisBens.xls.
WithOUT HisBens.xls in his XLSTART folder, Excel opens with calculation set
to automatic. No problem.
With HisBens.xls installed in his XLSTART folder, Excel opens with
calculation set to Manual.
I have no such problem with MyBens.xls file installed in my XLSTART folder.
So he sends me HisBens.xls file.
I install HisBens.xls file in place of MyBens.xls file in my XLSTART folder.
I have the same problem he has.
HisBens.xls file has no Auto_Open file. No Workbook_Open file. No
protected (hidden) modules.
Does anyone have any clues or ideas as to why this is happening? Thanks for
your help. Otto


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help!Excel will not calculate formulas- Not in manual calculation Lisa Excel Worksheet Functions 6 December 9th 08 12:47 PM
Excel Manual Calculation Brandon Excel Worksheet Functions 4 April 25th 08 07:16 PM
Manual Calculation in Excel 2000 dm Excel Discussion (Misc queries) 11 February 26th 07 12:56 PM
why does excel keep defaulting to manual calculation? Ruth Excel Discussion (Misc queries) 2 August 18th 06 04:19 PM
Excel Opens with Manual Calculation option on instead of Auto rich32822 Excel Programming 1 February 18th 05 09:01 AM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"