excel problem...another one

[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