ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   WHY I GET " CALCULATE" MESSAGE (https://www.excelbanter.com/new-users-excel/109705-why-i-get-calculate-message.html)

dfg

WHY I GET " CALCULATE" MESSAGE
 
i get the calculate message in status bar, i copy the formula in one
perticular sheell and then paste this to some other shell but the formula is
not applied to other shells, it shows always the first copied shell value to
forth comming shells


in status bar show the message " calculate"

what can i do

Max

WHY I GET " CALCULATE" MESSAGE
 
Think the calc mode is inadvertently set to Manual.
Press F9, does it compute properly?

To check & change calc mode:
Click Tools Options Calculation tab
Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dfg" wrote:
i get the calculate message in status bar, i copy the formula in one
perticular sheell and then paste this to some other shell but the formula is
not applied to other shells, it shows always the first copied shell value to
forth comming shells


in status bar show the message " calculate"

what can i do



All times are GMT +1. The time now is 10:31 AM.

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