linking to a workbook in a access restricted folder

**arun_lp** · 05-07-2012, 01:00 AM

We have two workbooks a timesheet and a tracking sheet placed in a network with many users. All users have their own tracking sheet and a single common timesheet placed in a access restricted folder. The problem is when a tracking sheet is linked with the timesheet it doesn’t work. Can anyone help me with linking these workbooks without affecting the access rights?

**shekhar1660** · 05-07-2012, 09:46 AM

Hi Arun,
Without having access rights of that particular folder, no one can access the workbook or worksheet even by clicking on the Hyperlink.

Regards
Shekhar Sharma

**arun_lp** · 05-08-2012, 12:45 AM

Is there any way placing the timesheet globally but no users must have access to it? Please Help

**shekhar1660** · 05-09-2012, 04:56 AM

Hi Arun,

If you are using any kind of lookup function, it will work without having access to that folder.
However every time you will get the promt to update the values after opening the workbook (you have lookup).
As of now no other option I can think of accessing the workbook from restricted folder.

Shekhar Sharma