ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Links to other workbooks (https://www.excelbanter.com/excel-worksheet-functions/49017-links-other-workbooks.html)

catalyst October 6th 05 03:22 PM

Links to other workbooks
 

Hi there
I have created a workbook which links to 5 other workbooks and my
formulas pull the data out of the 5 and put it into one consolidated
workbook, however the main workbook wont update until I open the other
files, obviously this is not very practicle as I want it to contanually
update.
The error I get is Warning: open source to update
Any ideas?


--
catalyst
------------------------------------------------------------------------
catalyst's Profile: http://www.excelforum.com/member.php...o&userid=27875
View this thread: http://www.excelforum.com/showthread...hreadid=473779


wbeaumont October 6th 05 08:34 PM


My situation is very similiar and have no solution. The MS office
online help has been no help so far but will keep digging. If I find
anything you may find useful I will pass it on. Good hunting.


--
wbeaumont
------------------------------------------------------------------------
wbeaumont's Profile: http://www.excelforum.com/member.php...o&userid=27868
View this thread: http://www.excelforum.com/showthread...hreadid=473779



All times are GMT +1. The time now is 04:22 PM.

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