Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default message 'calculate'


Hi,
i am facing peculiar problem, which is when i am moving from cell to
another cell there is a message on the down toolbar saying 'calculate'.
it will only move when i press the save button. otherwise that message
is staying there and everything will struck as it is. Is that a virus
or any bug in excel. I need quick help for any one .
thanks
and regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=541462

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 244
Default message 'calculate'

Calculation is set to manual - tools, options, then the calculate tab
and reset to automatic or in code
application.calculation=xlautomatic

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default message 'calculate'

Hi,

Try to change the following setting: Tools/Options/Calculation and
select the checkbox "Manual" (it is now probably on "Automatic")

HTH

Rgds,
Robert

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default message 'calculate'


Hi Nowfal,

Have a read of (& the linked pages):

http://www.decisionmodels.com/calcsecretsf.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=541462

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default message 'calculate'


Hi,
Done, very thanks to Mr.Robert,Mr.Norman and Mr.Aidan.

nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=541462



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default message 'calculate'

Hi Nowfal,

Try:

Tools | Options | Calculation | select the Automatic option.


---
Regards,
Norman


"nowfal" wrote in
message ...

Hi,
i am facing peculiar problem, which is when i am moving from cell to
another cell there is a message on the down toolbar saying 'calculate'.
it will only move when i press the save button. otherwise that message
is staying there and everything will struck as it is. Is that a virus
or any bug in excel. I need quick help for any one .
thanks
and regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=541462



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
Calculate message Mark Excel Discussion (Misc queries) 1 March 25th 09 12:27 PM
Calculate message David Excel Discussion (Misc queries) 1 March 18th 08 09:15 PM
Calculate message Holly Excel Discussion (Misc queries) 1 August 15th 06 08:03 PM
Calculate message Alan P Excel Discussion (Misc queries) 1 June 21st 06 06:05 PM
Calculate message Kelly Excel Discussion (Misc queries) 3 June 21st 05 06:53 PM


All times are GMT +1. The time now is 07:12 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"