B

#### Bill Schickling

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?