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

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