how to link excel cells across the internet?
 

In the Excel program running on my local PC, there is a single cell, whose
contents I would like to share with multiple clients at different locations
on the internet.

The contents of the cell is a string (255 characters max with no formatting)
and is updated about ten times a minute.

I want this continuously changing cell to be duplicated in the client excel
files in real time across the internet.

Can someone help me with instructions to do this?

how to link excel cells across the internet?
 

You'd need to have an accessible place to put the value (eg some web
space), and some way for the other files to query the value. Excel
doesn't have this capability built in. Do you really mean internet
and not intranet?

Tim




"Paul" wrote in message
...
In the Excel program running on my local PC, there is a single cell,
whose
contents I would like to share with multiple clients at different
locations
on the internet.

The contents of the cell is a string (255 characters max with no
formatting)
and is updated about ten times a minute.

I want this continuously changing cell to be duplicated in the
client excel
files in real time across the internet.

Can someone help me with instructions to do this?

how to link excel cells across the internet?
 

Thanks Tim,

The internet is what I need to cross with this data. But if you know how to
do it on an intranet, I would be interested in that too - as a starting
place. I do not know how to do what you are suggesting. Please explain.

I understand that there may be a way to do this type thing with a vpn, but
so far i remain clueless as to how to accomplish it inreality.

Thanks again for your response!

"Tim Williams" wrote:

You'd need to have an accessible place to put the value (eg some web
space), and some way for the other files to query the value. Excel
doesn't have this capability built in. Do you really mean internet
and not intranet?

Tim




"Paul" wrote in message
...
In the Excel program running on my local PC, there is a single cell,
whose
contents I would like to share with multiple clients at different
locations
on the internet.

The contents of the cell is a string (255 characters max with no
formatting)
and is updated about ten times a minute.

I want this continuously changing cell to be duplicated in the
client excel
files in real time across the internet.

Can someone help me with instructions to do this?

how to link excel cells across the internet?
 

I think your best bet for using the net to transmit data would be t
export the data down to a sql database or use access with a databas
server

--
JasonSel
-----------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...nfo&userid=533
View this thread: http://www.excelforum.com/showthread.php?threadid=46663

how to link excel cells across the internet?
 

Paul,

If it were an intranet then a shared network folder might be enough.
On the internet you could use a web page which would accept a
parameter (the value from your "master" spreadsheet) and then pass it
on to any request made by the "slave" spreadsheets. This would equate
to a "pull" approach rather than a "push" process - ie. you're relying
on the slave files "asking" for the updated value.

Every six seconds is quite frequent though...

Tim

"Paul" wrote in message
...
Thanks Tim,

The internet is what I need to cross with this data. But if you
know how to
do it on an intranet, I would be interested in that too - as a
starting
place. I do not know how to do what you are suggesting. Please
explain.

I understand that there may be a way to do this type thing with a
vpn, but
so far i remain clueless as to how to accomplish it inreality.

Thanks again for your response!

"Tim Williams" wrote:

You'd need to have an accessible place to put the value (eg some
web
space), and some way for the other files to query the value. Excel
doesn't have this capability built in. Do you really mean internet
and not intranet?

Tim




"Paul" wrote in message
...
In the Excel program running on my local PC, there is a single
cell,
whose
contents I would like to share with multiple clients at different
locations
on the internet.

The contents of the cell is a string (255 characters max with no
formatting)
and is updated about ten times a minute.

I want this continuously changing cell to be duplicated in the
client excel
files in real time across the internet.

Can someone help me with instructions to do this?