Help and Support
 

powered byLive Search

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

Article ID:284875
Last Review:June 27, 2007
Revision:4.1
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.

Back to the top

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.

Back to the top

WORKAROUND

To work around this issue, give permissions to domain users and groups instead of local users and groups.

Back to the top

STATUS

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

Back to the top

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.

Back to the top


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

Back to the top

Keywords: 
kbbug kbpending KB284875

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.