Article ID: 284875 - Last Review: June 27, 2007 - Revision: 4.1

Local user and group permissions for Excel are valid on any computer

This article was previously published under Q284875
Expand all | Collapse all

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Microsoft Windows NT, Microsoft Windows 2000, and Windows Vista 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, Windows 2000, and Windows Vista 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.

APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition, when used with:
    • the operating system: Microsoft Windows 2000
    • Microsoft Windows NT 4.0
Keywords: 
kbbug kbpending KB284875
 

Article Translations

 

Related Support Centers