Problem with links

P

Peter

I'm having a problem with a link. I have a work book
called 'Graveyard Shift' and a sheet within that workbook
called 'Graveayd Charts'. I also have a 'YTD' workbook. I
have the charts linked from 'Graveyard Charts' to 'YTD'
I am getting an error that says Invalid Refernce. I
checked it , it is right. When I have 'Graveyard Charts'
open then everything updates perfectly. Any help?
 
J

Jon Peltier

Peter -

If the links use some kind of dynamic function (INDIRECT, OFFSET), the
source workbook has to be open. Links to closed workbooks only work
with nondynamic cell references and named ranges.

- Jon
 
Top