Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filename rewritten to [0]
Hi,
Using Excel 2007. I'm using a dynamic data sources on a chart using named regions. I have a name region called 'Bob' which is as follows: =OFFSET('Sheet1'!$B$2,0,0,COUNT('Sheet1'!$B$2:$B$2 4),1) and the Series Values in my chart is: ='my workbook.xlsx'!Bob Everything works ok until i save, close and re-open the workbook. The Series Values formula changes to =[0]!Bob and therefore no longer works when the data changes Does anyone have any idea why this happens and/or how to fix it? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filename from a Cell | Excel Worksheet Functions | |||
Concatinate a filename | Excel Discussion (Misc queries) | |||
filename pointer | Excel Worksheet Functions | |||
Filename at the very top of Microsoft Excel Window | Excel Discussion (Misc queries) | |||
Insert value of a cell as a filename | Excel Worksheet Functions |