Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't get excel to calculate | Excel Worksheet Functions | |||
Turn off calculate event | Excel Discussion (Misc queries) | |||
any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) |