Ecxel Problem

[TheeOx]

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.

Thanks,
Thee

Dont worry about the world ending today,
'cause it's already tomorrow in Austrailia.

 

[SkipVought]

Hi,

You can have a workbook on a common network that each of your users can access. Set up your workbook as a SHARED workbook. You'll have to educate yourself regarding the pros and cons of shared workbooks. There are definite obvious and not so obvious drawbacks.

You might ought to consider a database application like MS Access for storing your data. Chances are, though, if you have no experience with database storage/access/maintenance techniques, you're thinking of your workbook as BOTH a storage medium AND a report. You, more than likely, have designed the workbook to LOOK LIKE the data that you want to report, which is almost ALWAYS, vastly different than the way it ought to be STORED -- a mistake that makes data analysis and other report formats vitually impossible.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}