Linking to cells on a spreadsheet with controlled access
 

We use an Excel spreadsheet here on our network that has controlled access
(only certain people have access to the directory where it is stored). I am
in charge of a daily meeting where we review data from this spreadsheet.
Several different people will need to access the data on this spreadsheet,
but do not have permissions to access the directory where it is stored.
Rather than go through the IT nightmare of gaining proper permissions for
several new people to have access to the directory where this spreadsheet is
stored, I thought that I would create a spreadsheet that links to the data we
will need to see in my daily meeting. I would store this spreadsheet in a
directory where everyone in my meeting would have access to it. My question
is this: can someone who does not have permissions to access the directory
where the original spreadsheet is stored, open the new "linked" spreadsheet
and be able to update the links?

Linking to cells on a spreadsheet with controlled access
 

Just make sure that the "linked" (public) workbook has the proper cells
protected.

Another added task you will have to address is that once the "hidden"
workbooks have been updated, someone with global permissions will have to
open the "public" workbook, refersh the links and then save it. This is
because users without global permissions will not be able to do the refresh
on their computers
--
Gary''s Student - gsnu200737


"DOOGIE" wrote:

We use an Excel spreadsheet here on our network that has controlled access
(only certain people have access to the directory where it is stored). I am
in charge of a daily meeting where we review data from this spreadsheet.
Several different people will need to access the data on this spreadsheet,
but do not have permissions to access the directory where it is stored.
Rather than go through the IT nightmare of gaining proper permissions for
several new people to have access to the directory where this spreadsheet is
stored, I thought that I would create a spreadsheet that links to the data we
will need to see in my daily meeting. I would store this spreadsheet in a
directory where everyone in my meeting would have access to it. My question
is this: can someone who does not have permissions to access the directory
where the original spreadsheet is stored, open the new "linked" spreadsheet
and be able to update the links?