View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Reference & update destin. cells on 1st machine from source workbook on 2nd machine.

Hi. Thanks for the reply. My goal is to have the destination cells to
update in more-or-less real time to the content of the source cells:
this while both workbooks are open and without having to save the
source workbook. I would seem from what you say that this is not
possible.

I gave a shot at the data menu to establish connections to retrieve
data , but the Wizard seems to require source data formatted as a
table.
I'm rather out of my depth in that case.

Joe