M
Mr. X
Using Excel 2002.
I have a workbook with 12 worksheets (one for every month of the
year), wherein a lot of the information is looked-up (using VLOOKUP)
in simples arrays.
I saw no point in implementing the arrays as a 13th worksheet, because
I will have a yearly version of my monthly worksheets in one workbook
(so one for 2003, 2004, etc). If I change the array(s), I want them to
be reflected in all referencing cells.
Problem:
If my workbook containing my arrays (called "Global") is loaded, I
have no problem and the references to it read as:
(blabla) 'Global.xls'!Roster (blabla) where "Roster" is a named cell
in this example.
If "Global" is not loaded (and I don't why it should be), then the
references change to:
(blabla) 'F:\Excel\Global.xls'!Roster (blabla) and all cells
containing such references indicate "#REF!".
Why?
Any help appreciated.
Thanks.
M.T.
I have a workbook with 12 worksheets (one for every month of the
year), wherein a lot of the information is looked-up (using VLOOKUP)
in simples arrays.
I saw no point in implementing the arrays as a 13th worksheet, because
I will have a yearly version of my monthly worksheets in one workbook
(so one for 2003, 2004, etc). If I change the array(s), I want them to
be reflected in all referencing cells.
Problem:
If my workbook containing my arrays (called "Global") is loaded, I
have no problem and the references to it read as:
(blabla) 'Global.xls'!Roster (blabla) where "Roster" is a named cell
in this example.
If "Global" is not loaded (and I don't why it should be), then the
references change to:
(blabla) 'F:\Excel\Global.xls'!Roster (blabla) and all cells
containing such references indicate "#REF!".
Why?
Any help appreciated.
Thanks.
M.T.