Thread: Sharing data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OkiePC OkiePC is offline
external usenet poster
 
Posts: 1
Default Sharing data


Hello, I'm new to the forum.
I have an excel workbook on a dedicated PC that retrieves data from
production equipment in near real time. I have created a workbook on
our plant server that references this data. I want to be able to get
the latest data to anyone who opens this workbook. Currently, the data
is only updated when the primary workbook is saved by the main PC. I
need to be able to program it to save the file every 15 seconds, or
find a way to link the other workbook to the open one so the data is
updated constantly.

Thanks in advance
Paul C.


--
OkiePC
------------------------------------------------------------------------
OkiePC's Profile: http://www.excelforum.com/member.php...o&userid=28548
View this thread: http://www.excelforum.com/showthread...hreadid=482072