dependant cells do not update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm experiencing a problem I can't figure out. My workbook has one sheet that is strictly data, and all the other sheets depend on it. The automatically calulate option is turned on but the cells do not always update when I change the data in the main sheet. Frustrating because it works most of the time but will suddenly cease to update
If I fill a 12x12 table with data, all the dependant sheets update, then if I clear the contents of the table, the dependant cells keep the old values. What gives?

thank

DCR
 
DCR said:
I'm experiencing a problem I can't figure out. My workbook has one sheet
that is strictly data, and all the other sheets depend on it. The
automatically calulate option is turned on but the cells do not always
update when I change the data in the main sheet. Frustrating because it
works most of the time but will suddenly cease to update.
If I fill a 12x12 table with data, all the dependant sheets update, then
if I clear the contents of the table, the dependant cells keep the old
values. What gives??
Click to expand...

This can happen when you have lots of formulas, lots of lookup/match
function calls or just plain huge spreadsheets. Roughly how large is this
file? How many cells contain formulas? How many VLOOKUP, HLOOKUP, LOOKUP and
MATCH calls are there? Anyway, search Microsoft's KnowledgeBase for Excel on
'Calculation'.
 
Thanks for your reply,
The file is 384KB, not huge but there are alot of formulas. The file is used to track monthly sales, so has a sheet for each month and some charts (about 20 sheets). The formulas are simple sums and products with a few IFs thrown in. I suppose the bulk of the formulas are references to other cells on other sheets-most cells have a reference.
( I am not familiar with the terms VLOOKUP etc.).
I replaced = with = on all sheets and it seems to be working now

DCR

----- Harlan Grove wrote: -----

DCR said:
I'm experiencing a problem I can't figure out. My workbook has one sheet
that is strictly data, and all the other sheets depend on it. The
automatically calulate option is turned on but the cells do not always
update when I change the data in the main sheet. Frustrating because it
works most of the time but will suddenly cease to update.
If I fill a 12x12 table with data, all the dependant sheets update, then
if I clear the contents of the table, the dependant cells keep the old
values. What gives??
Click to expand...

This can happen when you have lots of formulas, lots of lookup/match
function calls or just plain huge spreadsheets. Roughly how large is this
file? How many cells contain formulas? How many VLOOKUP, HLOOKUP, LOOKUP and
MATCH calls are there? Anyway, search Microsoft's KnowledgeBase for Excel on
'Calculation'.
 
Back
Top