Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Prevent Manual Calculation Mode

Is there a way to prevent the manual calculation mode. It seems 2003 "knows"
when to set it. In most cases I find it annoying when results are obviously
not what they're supposed to be, and I haven't set the manual mode myself.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Prevent Manual Calculation Mode

Hi,

This 'feature' of Excel causes it to remember the calculation setting of the
first workbook opened in a session so if that workbok was set to calculation
manual then it picks up that setting.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Evan Weiner" wrote:

Is there a way to prevent the manual calculation mode. It seems 2003 "knows"
when to set it. In most cases I find it annoying when results are obviously
not what they're supposed to be, and I haven't set the manual mode myself.

Reply
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
Manual Calculation in Excel 2007 with Calculate mode set to Automatic Julie White Excel Worksheet Functions 1 November 24th 09 09:38 PM
Spreadsheet constantly reverts to manual calculation mode JR Hester Excel Discussion (Misc queries) 3 September 10th 07 03:58 PM
manual calculation mode Victor Excel Discussion (Misc queries) 0 June 18th 07 10:44 PM
Open CSV causes calculation in manual calc mode [email protected] Excel Discussion (Misc queries) 0 July 25th 06 09:22 PM
My Calculation Mode Changed to Manual Somehow?!? Jeb Excel Discussion (Misc queries) 2 August 4th 05 03:40 PM


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

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

About Us

"It's about Microsoft Excel"