Thee Ox

Hi all,

Does Excel have the capability to link excel spreadsheets to a master spreadsheet via personal computers?
Here's a better description:
There is one master Excel spreadsheet on one PC.
Several other people have weekly spreadsheets that they will fill out. Can the employee spreadsheets be linked to automatically update on the master spreadsheet?
I have been searching high and low but to no avail.

I appreciate all yer help.

Cromewell

You can link to external tables in excel so I don't see why the external table needs to be on the current PC.

inter-workbook link:
'C:\DATA\COSTS.XLS'!$A$2

if a workbook contains several sheets, then the name of the sheet has to be specified, using the same syntax as is used in Excel for an inter-workbook link:
'C:\DATA[COSTS.XLS]Sheet3'!$A$2

__________________

You know what the chain of command is? It's the chain I go get and beat you with 'til ya understand who's in ruttin' command here.

I must plug a couple comics because they are good :D:
www.ctrlaltdel-online.com
www.userfriendly.org