| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linked cells to workbooks in different folders | Excel Discussion (Misc queries) | |||
| LINKED WORKBOOKS - TOTAL CONFUSION | Excel Worksheet Functions | |||
| Finding linked cells to other workbooks | Excel Discussion (Misc queries) | |||
| Updating linked workbooks | Excel Discussion (Misc queries) | |||
| Controlling Linked Data to Workbooks | Excel Worksheet Functions | |||
Hybrid Mode
