Problem with links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 14 Dec 2003 14:01 GMT

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?

Reply to this Message

Jon Peltier - 15 Dec 2003 16:02 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I'm having a problem with a link. I have a work book
> called 'Graveyard Shift' and a sheet within that workbook
[quoted text clipped - 3 lines]
> checked it , it is right. When I have 'Graveyard Charts'
> open then everything updates perfectly. Any help?

Reply to this Message