Discussion:
Folder Permissions & 2007
(too old to reply)
Linz
2009-12-22 17:21:02 UTC
Permalink
We have a share drive that contains multiple folders with individual
spreadsheets that each user maintains. We have set up these folders with
protection so users can’t delete the spreadsheets, copy others or modify the
contents, only save/edit what already exists. A group was created with the
users as members, permissions were granted to “Allow” all permissions except
“Delete Subfolders & File” and “Delete”, and these are marked as “Deny”.
Since there are multiple folders, they all inherit permissions from the main
folder.

In Excel 2003, the users are able to save as needed. Now with a few testers
that have been upgraded to 2007, when they access this spreadsheet they are
no longer able to save; Access denied. Contact your administrator.

We have removed any protection to the spreadsheet, saved as 2003 & 2007
formats, created new spreadsheets in that same folders to verify nothing was
corrupt and tried different computers and profiles. Nothing seems to work.

Has anyone run across a similar issue? What would cause 2007 to treat
folder permissions differently?
Trish Patitz
2011-04-05 22:19:48 UTC
Permalink
Yes, I have the same issue. I have saved a file on a shared drive as xlsx and have also tried to save it as xls. As soon as another user opens it and makes changes to it it becomes read-only to me and I cannot edit it at all.
I am operating on Excel 2007 and the other user is on Excel 2003.
Post by Linz
We have a share drive that contains multiple folders with individual
spreadsheets that each user maintains. We have set up these folders with
protection so users can???t delete the spreadsheets, copy others or modify the
contents, only save/edit what already exists. A group was created with the
users as members, permissions were granted to ???Allow??? all permissions except
???Delete Subfolders & File??? and ???Delete???, and these are marked as ???Deny???.
Since there are multiple folders, they all inherit permissions from the main
folder.
In Excel 2003, the users are able to save as needed. Now with a few testers
that have been upgraded to 2007, when they access this spreadsheet they are
no longer able to save; Access denied. Contact your administrator.
We have removed any protection to the spreadsheet, saved as 2003 & 2007
formats, created new spreadsheets in that same folders to verify nothing was
corrupt and tried different computers and profiles. Nothing seems to work.
Has anyone run across a similar issue? What would cause 2007 to treat
folder permissions differently?
Jack Toff
2011-04-06 12:34:14 UTC
Permalink
The only issue you have is being a hooplehead for replying to a post
from 2009.
Post by Trish Patitz
Yes, I have the same issue. I have saved a file on a shared drive as xlsx and have also tried to save it as xls. As soon as another user opens it and makes changes to it it becomes read-only to me and I cannot edit it at all.
I am operating on Excel 2007 and the other user is on Excel 2003.
Post by Linz
We have a share drive that contains multiple folders with individual
spreadsheets that each user maintains. We have set up these folders with
protection so users can???t delete the spreadsheets, copy others or modify the
contents, only save/edit what already exists. A group was created with the
users as members, permissions were granted to ???Allow??? all permissions except
???Delete Subfolders& File??? and ???Delete???, and these are marked as ???Deny???.
Since there are multiple folders, they all inherit permissions from the main
folder.
In Excel 2003, the users are able to save as needed. Now with a few testers
that have been upgraded to 2007, when they access this spreadsheet they are
no longer able to save; Access denied. Contact your administrator.
We have removed any protection to the spreadsheet, saved as 2003& 2007
formats, created new spreadsheets in that same folders to verify nothing was
corrupt and tried different computers and profiles. Nothing seems to work.
Has anyone run across a similar issue? What would cause 2007 to treat
folder permissions differently?
Loading...