ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linked workbook(s) (https://www.excelbanter.com/excel-discussion-misc-queries/81237-linked-workbook-s.html)

Tom

Linked workbook(s)
 
I have a workbook "book 1" that is feed from several other workbooks "books
2,3,4,and 5" When I open book 1 the links do not update with the other (4)
books information. When starting book 1, I do select the update workbook
button, however I get an "unable to read file" warning message.
How do I correct this problem?
TFTH,
Tom

Crazymom999

Linked workbook(s)
 
Hi, As far as i know, you need to open all workbooks which this Book1 gets
info from. Once all books are open - then book1 can update. This may be the
long way round, hopefully someone might have the quick way round. Hope this
helps. Regards, Crazymom

"Tom" wrote:

I have a workbook "book 1" that is feed from several other workbooks "books
2,3,4,and 5" When I open book 1 the links do not update with the other (4)
books information. When starting book 1, I do select the update workbook
button, however I get an "unable to read file" warning message.
How do I correct this problem?
TFTH,
Tom



All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com