Fix Greyed-Out Excel Data and Formatting Tools in Protected Workbooks
Question details
The user needs to restore access to greyed-out Data and formatting commands in an Excel workbook that may be protected, read-only, shared with restrictions, or controlled by a macro.
- Product
- Microsoft Excel and WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opened an Excel workbook and found that Data tab and formatting commands are unavailable, preventing editing or analysis.
- Observed behavior
- Excel Data and formatting commands are greyed out and cannot be clicked.
Before changing protection settings, confirm that the workbook is not currently opened in Protected View or marked as read-only, and create a new blank workbook to check whether the issue is specific to the file.
Unprotect the Active Worksheet in WPS Office Spreadsheets
Use this solution first when specific formatting and Data commands are greyed out on one sheet but work in a new workbook.
Worksheet protection is the most common reason Data and formatting tools become unavailable. Once the sheet is unprotected, the commands should return to their normal state.
In WPS Office Spreadsheets, click the Review tab on the ribbon.
In the Protect group, click Unprotect Sheet. If it shows Protect Sheet instead, the worksheet is not protected.
If a password prompt appears, enter the password provided by the file owner and click OK.
Click the Data tab or a formatting control to confirm that the greyed-out commands are now active.
Remove Workbook or Read-Only Restrictions
Use this solution if all sheets are protected, the Unprotect Sheet command is also greyed out, or the file opens as read-only.
Restore Greyed-Out Excel Data and Formatting Tools with WPS Office Spreadsheets
Open the Excel workbook in WPS Office Spreadsheets, use the Review tab to unprotect the sheet or workbook, and regain full access to Data and formatting commands while preserving .xlsx compatibility.
- 1. Open the affected workbook: Launch WPS Office Spreadsheets and open the Excel file that contains greyed-out tools.
- 2. Open the Review tab: Click the Review tab on the ribbon to access protection controls.
- 3. Unprotect the sheet or workbook: Select Unprotect Sheet or Unprotect Workbook and enter the password if required.
- 4. Confirm the tools are active: Click the Data tab or a formatting tool to verify that the commands are no longer greyed out.
Frequently Asked Questions
Why are Excel Data and formatting tools greyed out?
Common causes include worksheet or workbook protection, read-only mode, Shared Workbook restrictions, or macros. Check the Review tab for Unprotect Sheet or Unprotect Workbook, and create a new workbook to isolate the restriction.
How do I unprotect an Excel sheet without the password?
You cannot legitimately remove password protection without the password. If WPS Office prompts for a password, request it from the file owner. If the sheet is not password-protected, click Review > Unprotect Sheet to remove protection.
Does WPS Office support protected Excel files?
Yes. WPS Office Spreadsheets can open protected .xlsx files and provides Unprotect Sheet and Unprotect Workbook on the Review tab. Password-protected files still require the correct password.
What if the Unprotect Sheet button is also greyed out?
The workbook may be protected or shared. Check Review > Unprotect Workbook, close Protected View, save a new editable copy if the file is read-only, or test the file in a new workbook.
Can I edit a read-only Excel file in WPS Office?
Yes. Open the read-only file in WPS Office Spreadsheets, click File > Save As, and save a copy with a new name. You can also check File > Info > Protect Workbook to disable read-only recommended settings if permissions allow.
