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
The error I get is Warning: open source to update
Any ideas?

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'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.