Microsoft KB Archive/293445

= Frequently asked questions about workbook protection in Excel =

Article ID: 293445

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q293445



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.



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



Additional query words: inf XL2002 xl2003 XL2007

Keywords: kbhowto kbinfo KB293445

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.