Thanks for the response. Have done that. Have also set to manual and hit
F9. Neither resolves the problem.

"Niek Otten" wrote:

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill Schickling" wrote in
message ...
I'm using Excel 2003 w/ SP2 and have encountered a problem I don't recall
having before. I have a workbook where a summary sheet is used to
aggregate
the values in each of the cells in the rest of the sheets by using a
formula
with following syntax:
=sum('sheet1:sheetx'!Cn),
where "sheet1" is the name of the first sheet in the range of contiguous
sheets, "sheetx" is the name of the last sheet in that range, "C" is the
pertinent column letter for a cell (the columns in this workbook represent
years) and "n" is the pertinent row number.

When I insert a new column (for a new year) in the supporting worksheets
and
then copy an existing column in the summary sheet (with the above
formulas)
and insert it in the appropriate location in the summary sheet so that it
will refer to the proper column in the range of supporting sheets, the
formulas refer to the new column but the results don't reflect the sum of
the
values in the new column. The results reflect the sum of the values in
the
column from which the formulas were copied. If I simply hit (F2) and
enter,
without changing the formulas, they will then produce the proper results.
However, it seems to me that i shouldn't have to do this. The formulas
are
correct without editing them. Why don't the show the proper results
automatically? I've experimented with manual vs. automatic recalculation
and
with iterations to no avail. Anybody have any ideas? Is this a bug?