Recalculation Problem in Excel 2000

[Guest]

I have a workbook with mupliple tabs. On one of the tabs (well call it "TB Separate Co") there is an equation that says something like ='Initial TB'!E8. That cell on Inital TB is an input cell (no equations). The workbook is set to automatically recalc. Sometimes I will copy a row of information from another workbook and paste it to the Inital TB page which will update information including cell E8. Unfortunately on some occasions the equation on the TB Separate Co page doesn't update for the new information. I can save the file and reopen the file and it still does not update the information. However, if I hit F2 (Edit) and then hit Enter it updates the field

Last year I started using this file by taking another Excel file that had three tabs in it to start. The file now has about 30 tabs. Someone told me that if you take a file that has been updated through various versions of Excel and us it to expand upon this problem will sometimes occur. Don't know if there is any truth to that theory. The initial 3 pages were from such a file

This problem occurs at random from what I can tell and the example above could occur in numerous locations throughout the workbook. Is there any way to fix this problem to make sure the file will automatically update the cells as it would be very difficult to check each equation in the file to make sure it is updating properly.

 

[Dave Peterson]

I've never seen this behavior, but I've seen posts from people who say it's
happened to them.

You could try forcing a complete recalc:

This is from xl2002's help:

Calculate a worksheet or workbook now

Press F9 Calculates formulas that have changed since the last calculation, and
formulas dependent on them, in all open workbooks. If a workbook is set for
automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed since the last
calculation, and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open workbooks, regardless of
whether they have changed since last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and then calculates all
formulas in all open workbooks, regardless of whether they have changed since
last time or not.

(I think that the last one is new with xl2002.)

and if those didn't help, maybe
edit|replace
=
with
=

To force excel to recalculate the formulas on that page (you could even group
the pages first).

=====
Is it true? I don't know. But maybe you could do a small test and recreate a
few of your worksheets to see if that eliminates the problem?????