ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   calculate (https://www.excelbanter.com/excel-worksheet-functions/128286-calculate.html)

Susan

calculate
 
I have a list that is all text (addresses, phone etc); I don't think it has
any formulas at all. When I add a new entry, the "calculate" notice shows up
in the bottom frame (near Ready). Why?

I have other workbooks that LOOKUP in this one, but that can't be it , can it?

Dave F

calculate
 
Calculation settings are probably set to manual. Go to
Tools--Options--Calculations and set to automatic.

Dave
--
Brevity is the soul of wit.


"susan" wrote:

I have a list that is all text (addresses, phone etc); I don't think it has
any formulas at all. When I add a new entry, the "calculate" notice shows up
in the bottom frame (near Ready). Why?

I have other workbooks that LOOKUP in this one, but that can't be it , can it?



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

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