Windows

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)

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).

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

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

This question was auto closed due to inactivity