How to Fix Excel Data Options and Filters Unavailable in WPS Office
Question details
The user needs to restore Excel Data menu options, filters, copying, and formatting commands after they become unavailable when moving a workbook.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A workbook was moved or opened in WPS Office Spreadsheets or Excel, and the Data menu, filter controls, copy, and formatting commands stopped responding.
- Observed behavior
- Excel Data options, filters, copying, and formatting commands are unavailable or stop working. The workbook may have worksheet corruption, an unusual view, protection, or an active object selection.
Save a backup copy of the affected workbook, and note whether the file was moved from another location or opened in an unsupported view before troubleshooting.
Check Protection and Clear the Active Selection
Use this first when Data options, filters, or formatting commands appear unavailable after moving a workbook, because protection or an active object selection is the most common cause.
Worksheet protection, workbook protection, or a selected object can block Excel Data commands and filters. Clearing these settings usually restores the commands without rebuilding the file.
Open the affected workbook in WPS Office Spreadsheets.
Click the Review tab on the ribbon, then select Unprotect Sheet or Unprotect Workbook if available. Enter the password if prompted.
Press Esc or click an empty cell to clear any active object or range selection.
Return to the Data tab and test Filter, Sort, Copy, and formatting commands again.

Copy Values to a New Worksheet
Use this when the original worksheet structure is damaged and you need a clean worksheet for the same data.
Rebuild the Workbook by Exporting to CSV
Use this when protection checks and value-only pasting do not restore the Data commands, and you need a clean rebuild of the data.
Repair Excel Data Options and Filters in WPS Office Spreadsheets
Open the affected Excel workbook in WPS Office Spreadsheets, clear protection and active selections, and copy or rebuild the data so the Data menu, filters, copying, and formatting commands work normally.
- 1. Open workbook: Open the affected Excel workbook in WPS Office Spreadsheets.
- 2. Remove protection: Click the Review tab and choose Unprotect Sheet or Unprotect Workbook if protection is enabled.
- 3. Clear selection: Press Esc or click a blank cell to clear any active object or range selection.
- 4. Restore commands: Use the Data tab to reapply filters and sorting, or copy values to a new worksheet.
- 5. Save clean copy: Save the repaired file as .xlsx or .csv to keep a working copy.

Frequently Asked Questions
Why are Excel Data options and filters grayed out after moving a workbook?
This usually happens because the workbook has sheet or workbook protection, an active object selection, or worksheet corruption. In WPS Office Spreadsheets, open the file, click Review > Unprotect Sheet or Unprotect Workbook, press Esc to clear the selection, and test the Data tab again.
How do I unprotect an Excel sheet in WPS Office?
Open the workbook in WPS Office Spreadsheets and go to the Review tab. Click Unprotect Sheet or Unprotect Workbook, then enter the password if prompted. After protection is removed, Data filters and formatting commands should be available.
Can I recover Excel data if filters and formatting still do not work?
Yes. Select the data range, press Ctrl+C, create a new worksheet with the + icon, then right-click cell A1 and choose Paste Special > Values. If the sheet is still problematic, save the worksheet as CSV and open it in a new workbook.
Will saving an Excel workbook as CSV remove filters and formatting?
Yes. CSV files store only values, so filters, formulas, and formatting are not retained. Use CSV export to create a clean data set, then reapply filters and formatting in WPS Office Spreadsheets or Microsoft Excel.
Does WPS Office support Excel Data menu options and filters?
Yes. WPS Office Spreadsheets opens .xlsx, .xls, and .csv files and includes Data tab tools such as Filter and Sort, plus Review tab protection controls, so you can repair and work with Excel files without Microsoft Office.




