Linking two spreadsheets

  • Thread starter Thread starter shozil
  • Start date Start date
S

shozil

Hi,

I have a master document which includes training information for al
employess. Currently, we have tabs for each employee (small company)
which describes all of their daily/weekly tasks.

The problem is that you can't edit the file if someone else has i
open.

We'd like to create an individual spreadsheet for each employee an
still be able to display them in the master document. Is there a way t
pull all the data from the individual spreadsheets into the maste
document? I know you can link individual cells from multiple documents
but because we don't know how big each person's document may be, we nee
to link the entire document.

Sorry if I'm not very clear, I'll answer any questions to try an
clarify further.

Thank
 
Hi shozil,

The problem you state is that you cannot edit the document if someone else
is working on it. Is making the document a shared workbook an option? This
will allow multiple users full access at the same time if that is the only
issue. It can be done by clicking the Allow changes... check box through
Tools>Share Workbook menu. It does have some minor drawbacks, but works well
overall.
 
Back
Top