Excel automatically updating my sum across worksheets incorrectly

[Vaslo]

Why would =SUM('CP:2996_LE'!F13)

suddenly become?

SUM('CP:[2996_LE]2996_LE'!F13)? Excel refuses to let me delete the extra bracketed value and keeps putting it back in everytime i try to run it, and of course I get a #REF error.

Thanks.

[FDibbins]

to sum across worksheets, if it is a range on each worksheet, use...
=SUM(sheet1:Sheet4!C10:G10)
if it is a single cell per worksheet, use...
=SUM(sheet1:Sheet4!E11)

let me know how you make out

edit: looking at your 2nd formula, it looks like part/all of what you are trying to sum is a table?

[Vaslo]

It should be a single cell per worksheet summed across, but Excel seems to insist on adding this extra bracket of info. Makes no sense.

[FDibbins]

like i said, sounds like at least 1 cell on the sheets you are referencing is part of an excel "table". an excel table is a special function that allows extra capabilities. it looks like a regular range of rows of columns, but is not. to do a quick test, outside the table, just reference any cell within it...if you get the [] then its a range

edit: 1 way to overcome that is to manually enter the cell reference, instead of pointing to it