Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Frequently asked questions about workbook protection in Excel

Frequently asked questions about workbook protection in Excel

View products that this article applies to.

This article was previously published under Q293445

↑ Back to the top

Summary

Microsoft Excel provides multiple layers of protection to allow you to control who can access and change your data. These layers of protection are as follows:
  • Worksheet protection: You can protect elements on a worksheet (for example, cells with formulas) from all user access, or you can grant individual users access to the ranges that you specify.
  • Workbook-level protection: You can apply protection to workbook elements, and you can protect a workbook file from being viewed and edited. If a workbook is shared, you can protect it from being returned to exclusive use and prevent the change history from being deleted.

↑ Back to the top

More information

The following articles address some of the more frequently asked questions about workbook and worksheet protection in Excel:
  • How can I grant only a few users access to a range in my worksheet?
    289270� How to apply different passwords or permissions to separate ranges in worksheets in Excel
  • Why are users not allowed to edit the ranges that I established permissions for?
    277613� XL2002: Protected Ranges Not Adjusted When You Edit in Previous Versions of Excel
  • Why don't the permissions that I set on ranges in my worksheets carry over to Windows 98 computers?
    283665� XL2002: Password Required to Edit a Range Protected with NT Permissions

↑ Back to the top

Keywords: KB293445, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 293445
Revision : 4
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 372