LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Why not automatically updating calculations?

Could get turned by a macro or by an addin.
Turning off calculation will make macro run faster but forgetting to turn it back
on particularly when the macro abnormally terminates will leave calculation at manual.

If the problem recurs you can have your Excel tell you when you start up Excel that
calculation is not set at automatic and then perhaps you can remember what you
did in the previous session.
http://www.mvps.org/dmcritchie/excel...esp.htm#addins
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"walkingmac" wrote in message ...

ahh... yes, that did it. Thank you. Not sure how that could have been
disabled on throughout the machines, but yes, thanx.


--
walkingmac



 
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
Excel formulas are not automatically updating Sam M. via OfficeKB.com Excel Discussion (Misc queries) 3 January 9th 06 09:27 PM
Updating a chart automatically jeffsumm Charts and Charting in Excel 4 December 28th 05 08:01 PM
Automatically updating Graphs Rich Gibbons Excel Worksheet Functions 2 October 6th 05 01:17 PM
updating charts automatically Chris Charts and Charting in Excel 3 August 16th 05 03:18 PM
Updating calculations automatically when i enter in new data chica_guapa Excel Discussion (Misc queries) 1 February 8th 05 10:17 PM


All times are GMT +1. The time now is 07:37 AM.

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"