General discussion

Locked

Permission Disappears daily

By savvy ·
These are the details:

The AE's Excel (AE.xls) spreadsheet is reading info from the Accountant's spreadsheet (OPR.xls); ie OPR.xls is linked to AE.xls, so that when the AE's open their spreadsheet, excel asks if the user wants to update the links.

The AE's open their own AE.xls, but must not be able to open OPR.xls. Excel must be able to read from OPR.xls to AE.xls The linking must be able to be used, even though the AE musn't access OPR.xls.

This is what I did:
The "Accounting Folder" has the following permissions:
Accountant = full control
Sales MGR = Full Control
System = Read

In Folder A is OPR.xls and these are the file permissions:
MGR Full Control
Sales MGR - Read

(now comes the problem)
I add everyday
the Sales Group = Read

In Folder B is AE.xls:
Each AE has their own file (ie Gary.xls, Glen.xls, etc) and they have Read permission to the file, as do the Administrators.

I then added a shortcut on each AE's desktop to their respective file (AE.xls).

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Permission Disappears daily

by RobShan In reply to Permission Disappears dai ...

I suspect the permissions are being lost when the OPR files are changed and saved. Excel first saves a temporary file in the destination directory and then deletes the original files and renames the temporary file to the original file name. I would presume the temporary file is picking up the directory permissions. Normally I would expect Excel to take care of the permissions but it appears it isn't.

Work around: create a directory for the OPR sheets and set the directory permissions to include Sales Group = Read

(I can't reproduce the problem so there are probably additional factors at work here but believe the workaround above will get you through)

Collapse -

Permission Disappears daily

by savvy In reply to Permission Disappears dai ...

The question was auto-closed by TechRepublic

Collapse -

Permission Disappears daily

by MCSE Lee In reply to Permission Disappears dai ...

You say that "In Folder A is OPR.xls and these are the *file* permissions:" - you need to set these permissions on the folder, not the file, so that when the file is modified the correct permissions are applied automatically. If this poses a security issue, then create another folder and move the necessary file(s).

Collapse -

Permission Disappears daily

by savvy In reply to Permission Disappears dai ...

The question was auto-closed by TechRepublic

Collapse -

Permission Disappears daily

Hi!

As stated above and as I answerd this question earlier but got an rejection you need to set same pemissions on the folder in which the file resides.

/Hasse

Collapse -

Permission Disappears daily

by savvy In reply to Permission Disappears dai ...

The question was auto-closed by TechRepublic

Collapse -

Permission Disappears daily

by Curious_George In reply to Permission Disappears dai ...

Possibly because the system only has read access in some cases and none in others, maybe the permissions cannot be modified??

Collapse -

Permission Disappears daily

by savvy In reply to Permission Disappears dai ...

The question was auto-closed by TechRepublic

Collapse -

Permission Disappears daily

by savvy In reply to Permission Disappears dai ...

This question was auto closed due to inactivity

Back to Windows Forum
9 total posts (Page 1 of 1)  

Operating Systems Forums