Excel Performance Problems

How to Fix Excel Sheet View Sorting Not Working or Saving

Nimra MalikNimra Malik Oct 19, 2026 869 views

Question details

The user needs to retain sorting configurations and column widths independently for different Sheet Views in shared Excel workbooks.

How to Fix Excel Sheet View Sorting Not Working or Saving
Product
Microsoft Excel
Device & OS
not provided
Scenario
Managing multiple customized views for a shared or personal workbook to quickly switch between different data sorting priorities, such as deadlines or task priority.
Observed behavior
Sorting preferences and column widths are not saved or retained when switching between different Sheet Views in both the desktop and browser versions of Excel.
Before you start

Ensure your workbook is saved to OneDrive or SharePoint and that AutoSave is actively running, as Sheet Views require cloud synchronization to function.

Solution 1Recommended

Apply a Data Filter Before Sorting in Sheet View

Applying a filter to your worksheet data prior to sorting forces Excel to properly register and lock in the sort parameters for the specific Sheet View.

In some instances, applying a sort directly inside a Sheet View without an active filter causes the application to discard the sort when switching views. Forcing a filter beforehand acts as an anchor for your view settings.

1
Create a New Sheet View

Navigate to the 'View' tab on the Excel ribbon and click 'New' under the Sheet View group to initiate a temporary view.

2
Enable Filtering

Highlight the header row of your dataset, go to the 'Data' tab, and click the 'Filter' button to display filter dropdown arrows on your columns.

3
Execute the Sort

Click the newly added filter dropdown on the specific column you want to sort, and select your preferred sorting order (e.g., Sort A to Z).

4
Keep the View

Return to the 'View' tab and click 'Keep' to permanently save this customized, sorted view to your workbook.

Apply a Data Filter Before Sorting in Sheet View
Verify Synchronization: Switch between the default view and your newly saved Sheet View to confirm the sorting configuration is now retained independently.
Free Microsoft Office alternative

Experience Seamless Data Management with WPS Office

If you are frustrated by Excel's Sheet View bugs and browser-based column width limitations, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for managing complex spreadsheets without the hassle of persistent synchronization glitches.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite and follow the installation wizard.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly without any formatting conversion.
  3. 3. Sort and Manage Data: Utilize the Data tab to easily filter and sort your spreadsheets securely and reliably.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats without data loss.Lightweight architecture ensures fast loading and smooth data sorting.Familiar user interface requires no steep learning curve for Office users.Free built-in spreadsheet tools for robust data filtering, sorting, and management.
microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel Sheet View column widths not saving in the browser?

Excel for the web currently has a known limitation where newly created Sheet Views inherit the column width of the default view. Changing the column width in a browser-based Sheet View will not permanently save that specific width for the view.

Can I use Sheet Views in Excel without a Microsoft 365 subscription?

No, Sheet Views are a premium co-authoring feature available exclusively for Microsoft 365 subscribers working on files stored in SharePoint or OneDrive.

How can I submit a bug report about Excel's browser limitations?

You can submit feedback directly to Microsoft by navigating to the Help tab in Excel and selecting 'Feedback', or by visiting the official Microsoft Excel Feedback Community portal online.

Will applying a filter fix sorting issues for all users in a shared workbook?

Yes. When you apply a filter before sorting and save it as a 'Kept' Sheet View, that configured view becomes available to other co-authors in the shared workbook without disrupting their default view.