Monitor realtime data in Excel..

richg · Apr 29th, 2002, 04:11 PM

I want to monitor data from several (keyed in) "inputs" in a production line in excel. The display could consist of a varaible number of cells in rows in the sheet being formatted in colour related to accumulated data from each input.

It has been suggested to me that an intranet would be a good means of getting the inputs into excel.

If anyone can help me with the fundamentals of doing this I can supply more detail.

Thanks in advance for any help.

Parra · Apr 29th, 2002, 04:23 PM

It has been my experience that when more than 1 person at a time try to view a spreadsheet on a network, you get a message saying that "This workbook is being view by someone else, would you like to open this file as a read only?".

So what I am trying to say is, I myself do not think you can do what you want. I am not a pro, I am just letting you know from my experience.

NateO · Apr 29th, 2002, 04:25 PM

You could play with the "Share Workbook" functionality under the menu headings Tools->Share Workbook....(Especially if you have xl2000 (can't recall if this is in '97)

You loose a fair amount of Excel's functionality under this setting, but a file on a Network drive could be accessed and manipulated by multiple end-users at the same time. It won't be refreshed/replicated/updated real-time, though....

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-04-30 09:23 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 04:11 PM	#1
richg New Member Join Date: Apr 2002 Posts: 1	I want to monitor data from several (keyed in) "inputs" in a production line in excel. The display could consist of a varaible number of cells in rows in the sheet being formatted in colour related to accumulated data from each input. It has been suggested to me that an intranet would be a good means of getting the inputs into excel. If anyone can help me with the fundamentals of doing this I can supply more detail. Thanks in advance for any help.

Apr 29th, 2002, 04:23 PM	#2
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	It has been my experience that when more than 1 person at a time try to view a spreadsheet on a network, you get a message saying that "This workbook is being view by someone else, would you like to open this file as a read only?". So what I am trying to say is, I myself do not think you can do what you want. I am not a pro, I am just letting you know from my experience.

Apr 29th, 2002, 04:25 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You could play with the "Share Workbook" functionality under the menu headings Tools->Share Workbook....(Especially if you have xl2000 (can't recall if this is in '97) You loose a fair amount of Excel's functionality under this setting, but a file on a Network drive could be accessed and manipulated by multiple end-users at the same time. It won't be refreshed/replicated/updated real-time, though.... _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-04-30 09:23 ]