G
Grimaudiere
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Many of my spreadsheets use dynamic charts generated using formulae in named ranges as per this article:
<http://support.microsoft.com/kb/183446/en-us>
This works in Excel version 2008 with the slight change that I use the following in the chart data selection:
'Document name.xlsx'!DataName
where "DataName is the named range which uses OFFSET and RANGE functions. The use of the document name rather than the sheet name works in Excel 2007 when the name is a universal one, and works in 2008 as well, BUT, in 2008 (and not in 2007), when the sheet is saved and re-opened, the chart re-opens with:
"[0]!DataName"
in its data range. The "[0]" piece was originally the name of the spreadsheet as above.
How do I get Excel to save the document name properly?
This feels like a bug where when the chart is calculated it knows how to tell the difference between the document name and worksheet name in its data range, but the save and read functions is getting confused. But I fully admit it may be user error! It does work fine, though, in Office versions 2003 and 2007 on a PC.
Apologies if this has been asked before - I searched on named ranges and dynamic charts and could not fond a discussion so far!
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Many of my spreadsheets use dynamic charts generated using formulae in named ranges as per this article:
<http://support.microsoft.com/kb/183446/en-us>
This works in Excel version 2008 with the slight change that I use the following in the chart data selection:
'Document name.xlsx'!DataName
where "DataName is the named range which uses OFFSET and RANGE functions. The use of the document name rather than the sheet name works in Excel 2007 when the name is a universal one, and works in 2008 as well, BUT, in 2008 (and not in 2007), when the sheet is saved and re-opened, the chart re-opens with:
"[0]!DataName"
in its data range. The "[0]" piece was originally the name of the spreadsheet as above.
How do I get Excel to save the document name properly?
This feels like a bug where when the chart is calculated it knows how to tell the difference between the document name and worksheet name in its data range, but the save and read functions is getting confused. But I fully admit it may be user error! It does work fine, though, in Office versions 2003 and 2007 on a PC.
Apologies if this has been asked before - I searched on named ranges and dynamic charts and could not fond a discussion so far!