Things to consider :
- are the updates are two way or one way.
- how often is data being updated
- do you know when you need to refresh the data
- are you only looking at a few cells or larger amounts of data.
- does the worksheet layout change - is this limited to adding new
rows?
- is the other spreadsheet always open (is the other machine always
available) what do you do if these aren't available.
It is these sort of questions that help to determine an apropriate
solution
regards,
--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=516701