I read here in the MSDN Library, that "Names that are not referred to by any formula are not calculated even by a full calculation.".
- The Source Data for the Value of the chart series is in the form "='Copy of Test Report Rev 004.xls'!Chart1C1"
- The Named range Chart1C1 refers to = OFFSET(Chart1,Scroll,1,Zoom,1)
- Chart1 refers to ='Chart Data'!$A$4
- Scroll refers to='Chart Data'!$C$32
- Zoom refers to ='Chart Data'!$C$33
- Scroll and Zoom are both set scroll bars.
I have been unable to reproduce the problem on my 2003 installation.
Is it possible that the problem would occur in a workbook saved as an xlsx 2007 file as a consequence of Chart1C1 changing but not being referred to by any formula?
If this is the cause, could it be cured by referring to the named range in a hidden sheet (=Chart1C1), even though it would return an error?
I have attached a copy of the workbook for your entertainment.