Office Settings & Configuration

How to Fix Excel Data Options and Filters Unavailable in WPS Office

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

The user needs to restore Excel Data menu options, filters, copying, and formatting commands after they become unavailable when moving a workbook.

How to Fix Excel Data Options and Filters Unavailable in WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook

Open the affected workbook in WPS Office Spreadsheets.

2
Remove protection

Click the Review tab on the ribbon, then select Unprotect Sheet or Unprotect Workbook if available. Enter the password if prompted.

3
Clear the active selection

Press Esc or click an empty cell to clear any active object or range selection.

4
Test Data commands

Return to the Data tab and test Filter, Sort, Copy, and formatting commands again.

Check Protection and Clear the Active Selection
What to expect: After protection and selection are cleared, the Data tab commands and filters usually become available immediately.

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. 1. Open workbook: Open the affected Excel workbook in WPS Office Spreadsheets.
  2. 2. Remove protection: Click the Review tab and choose Unprotect Sheet or Unprotect Workbook if protection is enabled.
  3. 3. Clear selection: Press Esc or click a blank cell to clear any active object or range selection.
  4. 4. Restore commands: Use the Data tab to reapply filters and sorting, or copy values to a new worksheet.
  5. 5. Save clean copy: Save the repaired file as .xlsx or .csv to keep a working copy.
Restores Data menu, filter, copy, and formatting commands for Excel workbooks.Opens and saves .xlsx, .xls, and .csv files with Microsoft Office format compatibility.Free, lightweight Office suite with a familiar ribbon interface.Lets you clean and rebuild corrupted sheets without paying for Microsoft Office.
microsoft office alternative - wps office

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.