want to share workbook but limit the sheets each user sees

M

Mikekne

I have a budget workbook with different tabs for each department. These tabs
are also linked into support tabs. I would like to be able to save a master
workbook for each department but only allow them to see their own department
tab (10 different workbooks, each showing a different tab). Then use the
merge function to bring all the changes into the master.
 
S

Spiky

I have a budget workbook with different tabs for each department.  These tabs
are also linked into support tabs.  I would like to be able to save a master
workbook for each department but only allow them to see their own department
tab (10 different workbooks, each showing a different tab).  Then use the
merge function to bring all the changes into the master.

If you are going to give them each a separate file, anyway, why is
there an issue? Give them each a file with one worksheet for their
department, and have your master file reference each one.
 
M

Mikekne

Thank you for responding,

I would like to have secure way for each department manager to access one of
many workbook sheet while being easy to integrate the entries from 10
different people.

Spiky gave me a good answer below.
 
S

Spiky

Thank you,

That seems much too easy :) But you are correct
No problem.

You probably won't find it all that easy once you are trying to get a
dozen different files and departments on the same timeline. And
dealing with links in Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top