Hi. The updates are one-way only to the dest spreadsheet.
The source data is updated a couple of time per seconds. If it's
synchronized to the dest spreadsheet it would be great but if it's
updated every 2 or 3 seconds it would work too.
I'm looking at 30 to 60 cells max.
The layout at both ends is limited to adding new rows
The source spreadsheet is normally open while I use the dest
spreadsheet, but I need to be able to use the dest even if the source
is closed.
I would get the data into a separate sheet on my dest workbook, and
manipulate it from there.

Thanks,

Joe

tony h wrote:
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