ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   message 'calculate' (https://www.excelbanter.com/excel-programming/361293-message-calculate.html)

nowfal[_58_]

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


[email protected]

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


Robert[_30_]

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


Norman Jones

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




broro183[_94_]

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


nowfal[_59_]

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



All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com