EXCEL 2003 file doesn't update certain cells
 

I have an EXCEL file in which a few cells simply reference other cells
(e.g., = sheet2!a1) but when I changed the other cells on sheet 2,
they did not update. Yes, it is set to auto calculation.Originally,
it was auot except tables, but i changed it, clicked save, closed
EXCEL, and reopened and it did not help. I even reboooted the
computer.

If I go into the formula and edit it, that will fix it. If I save the
file with a new name, or even do a file save as and use the same name,
it updates. But if I merely hit the save icon in EXCEL, it stil does
not update, even if I shut down my computer and re-open, it still has
the old value.

The file does have a long name, although so do the new files that I
save it as, and thye are then fine, and react to further changes. I
even ran detect and repair.

Does anyone have a better answer than my file must be corrupt. It
seems that simply saving the file as a new name fixes this corruption,
but who can be sure it doesn't exist somewhere else?

I set it to manual, then back to automatic, but that didn't help
either.

In the past, closing EXCEL or even rebooting has made these kinds of
problems go away, but not this time.

Thanks
Dean

EXCEL 2003 file doesn't update certain cells
 

On 23/09/2010 19:31, DA wrote:
I have an EXCEL file in which a few cells simply reference other cells
(e.g., = sheet2!a1) but when I changed the other cells on sheet 2,
they did not update. Yes, it is set to auto calculation.Originally,
it was auot except tables, but i changed it, clicked save, closed
EXCEL, and reopened and it did not help. I even reboooted the
computer.

If I go into the formula and edit it, that will fix it. If I save the
file with a new name, or even do a file save as and use the same name,
it updates. But if I merely hit the save icon in EXCEL, it stil does
not update, even if I shut down my computer and re-open, it still has
the old value.

The file does have a long name, although so do the new files that I
save it as, and thye are then fine, and react to further changes. I
even ran detect and repair.

Does anyone have a better answer than my file must be corrupt. It
seems that simply saving the file as a new name fixes this corruption,
but who can be sure it doesn't exist somewhere else?

I set it to manual, then back to automatic, but that didn't help
either.

In the past, closing EXCEL or even rebooting has made these kinds of
problems go away, but not this time.

Thanks
Dean

I've seen something like this in a workbook in which I was using UDFs.

Changing a cell on one of the "feeder" sheets didn't update the result
sheet properly.

After trying to figure out what the problem was I settled for a work-around.

In the result sheet code page:

Private Sub Worksheet_Activate()
ActiveSheet.UsedRange.Columns("P:P").Calculate
End Sub

HTH