Chart Series Reference Lost on Save (Excel 2007)

[Guilty Lionel]

Hi, I'm having a problem with named ranges in a chart. I'm using Excel 2007 in Windows XP.

I have a line graph with twenty different series all using dynamic ranges. I created each series individually, typing the name and then the dynamic range I had previously defined. As far as I am aware, Excel demands when writing the reference that you specify which sheet/workbook this named range is from, so, given the scopes of my ranges are all 'workbook', I added the name of the workbook to the references.

e.g.
Series name:
Series1

Series values:
='workbook name'!range1

This seems to work fine, but when I save and then re-open the file, the dynamic ranges no longer work. If I go to Select Data and look at the reference for a series, it has been changed thus:

Series values:
=[0]!range1

Can anyone explain this? I've done similar things in other spreadsheets without probelm.

Thanks

 

[wratpack]

I'm having exactly the same problem. Did yuo manage to get it resolved?

 

[Guilty Lionel]

This was 4 and a half years ago, so I can't remember, no. I don't even remember posting this question. One thing I would suggest though, is making sure that your named range's reference uses absolute references (as in dollar signs). I find Excel's behaviour erratic when I don't do that.

 

[ftarantes]

Does anyone know how to fix that?

I'm facing the same problem, in excel 2010 the spreadsheet work well, but in 2007 lost reference as described above.

Thank you!