Problem with links

  • Thread starter Thread starter Peter
  • Start date Start date
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?
 
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
 
Back
Top