Series Data Problems
 

Okey Dokey....here's the dealeeo....HELP! HELP! I have a Excel 2007 Template
with charts that are driving me nutty! 2 of the 4 charts have the correct
series name of =sheet1 etc. and data series embedded - such as
filename.xltm!blah blah and they are working properly. However, the other 2
have a series name of =sheet1 etc. BUT the data series keeps showing [0]!
instead of sheet1! or filename.xltm! as it should. If I type sheet1! in, to
replace the [0]! the chart and formulas work fine. Yet when I close out and
save the template, and go back in, it is all screwed up again and the 2
charts and formulas aren't working again....UGH! Anybody that can help?
Please?!