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