#value

[skippy51]

I copy a worksheet say 2009 then rename the worksheet to 2010. I then go to a
cell that references another spreadsheet and do a find all 2009 and replace
2010 in the sumproduct formula. When I do this I get the #valve error that
states something in the formula is of the wrong data type. Why is this
happening and how can I correct it? I have many cells to do this on for the
new year.

 

[Bob Bridges]

I don't know from SUMPRODUCT, but is there any chance that the values you're
trying to change are numeric and when you change it to 2010 Excel changes the
data type to date? or vice versa?

There's something missing here: If you have formulae that refer to sheet
name "2009" and you rename the sheet, all those formulae should change
references automatically. Are you using INDIRECT in some of those cases?