Hello,

I've setup named ranges and am currently linking to them as the data ranges for my charts (this allows me to setup dynamic charts that auto-update based on newly added data). The actual process works fine, but I've been having a problem that is driving me crazy:

When I choose the source data, then "Series Values", I need to type something like this:
"=SheetName!Named_Range_Name"
OR "=WorkbookName.xls!Named_Range_Name"

Everything works fine, but when I save the file, close, and reopen, all of the references break and change to this:
"=[0]!Named_Range_Name", and they don't work anymore.

Very aggravating as I have a lot of charts. Is there some code I can type in instead of Sheetname or Workbookname that says "look in this workbook, whatever its name may be"?

I'm also using a binary excel file (.xlsb), if that makes a difference. If anyone can help me with this I'm trying to fix it soon so help would be much appreciated!

Thanks,
Colin