XL2002: Local User and Group Permissions Are Valid on Any Computer (284875)
The information in this article applies to:
- Microsoft Excel 2002, when used with:
- the operating system: Microsoft Windows 2000
- the operating system: Microsoft Windows NT 4.0
This article was previously published under Q284875 SYMPTOMS
If you specify permissions on ranges in a Microsoft Excel workbook to allow users access to parts of that protected workbook, a user without permissions may be able to edit those ranges on a different computer.
CAUSE
This behavior can occur if all of the following conditions are true:
- A local user or group on your computer is given permission to edit the range.
- A local user or group with the same name exists on another computer.
- A user on another computer, who either has that local user name or who is a member of that local group, opens the workbook.
WORKAROUND
To work around this issue, give permissions to domain users and groups instead of local users and groups.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
Microsoft Windows NT and Microsoft Windows 2000 have access control lists (ACLs) that contain computer, user, and group names. When you open a workbook in which the permission to edit ranges is assigned to a user or group, Windows NT and Windows 2000 match the user name or group name with a valid member in the ACL. If a local user or group matches the text, that local user or group has permission to edit the range.
| Modification Type: | Major | Last Reviewed: | 11/13/2003 |
|---|
| Keywords: | kbbug kbpending KB284875 |
|---|
|