is this possible please

[TIDMAN]

Hi there all, I need some help with a problem
here goes.
I have set up some lcd displays through out our plant run from one p
hooked upto the server and they work fine the problem i am about to ge
is with excel, what my boss wants is to display 2 spread sheets on eac
of the monitors wich has to be real time so when they make a change t
the original spread sheets on the server they would like the monitor
to display the updated spreadsheets because i know there are all kind
of issues with openning excel when somebody already has the sam
spreadsheet open.
Is there a way to get excel to refresh say every 5 seconds and have i
display one spread sheet for 5 seconds and then the other for another
seconds and repeat indefanatly.

Can this be done and if so any idea how??? if not any ideas on som
other way of doing this please thanks.

Thanks so very much in advance:confused

 

[Arvi Laanemets]

Hi

You can use ODBC query to retrieve the data from source table.
1. Define both source tables as non-dynamic named ranges, and then save
source tables.
2. In your display-workbook, insert 2 sheets
3. In either of sheet, create an ODBC query (Excel tables) from one of
source tables.
4. Set both queries to be refreshed after every minute (likely you can't go
for shorter times, but you can try anyway - but the quering takes some time
too.
5. About switching between sheets automatically - I have no clue.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

Hi there all, I need some help with a problem
here goes.
I have set up some lcd displays through out our plant run from one pc
hooked upto the server and they work fine the problem i am about to get
is with excel, what my boss wants is to display 2 spread sheets on each
of the monitors wich has to be real time so when they make a change to
the original spread sheets on the server they would like the monitors
to display the updated spreadsheets because i know there are all kinds
of issues with openning excel when somebody already has the same
spreadsheet open.
Is there a way to get excel to refresh say every 5 seconds and have it
display one spread sheet for 5 seconds and then the other for another 5
seconds and repeat indefanatly.

Can this be done and if so any idea how??? if not any ideas on some
other way of doing this please thanks.

Thanks so very much in advance

creating financial statements

 

[TIDMAN]

Thanks for the reply Arvi Laanemets, iw ill give that a try and see wha
happens.

Thanks again.

TIDMAN.......: