How to Fix Excel Sheet View Sorting Not Working or Saving
Question details
The user needs to retain sorting configurations and column widths independently for different Sheet Views in shared Excel workbooks.

- 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.
Ensure your workbook is saved to OneDrive or SharePoint and that AutoSave is actively running, as Sheet Views require cloud synchronization to function.
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.
Navigate to the 'View' tab on the Excel ribbon and click 'New' under the Sheet View group to initiate a temporary view.
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.
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).
Return to the 'View' tab and click 'Keep' to permanently save this customized, sorted view to your workbook.

Update Microsoft Excel to the Latest Build
Certain older Office builds experience known synchronization bugs with Sheet Views. Updating your application can patch these retention issues.
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. Download and Install: Visit the official WPS Office website to download the free suite and follow the installation wizard.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly without any formatting conversion.
- 3. Sort and Manage Data: Utilize the Data tab to easily filter and sort your spreadsheets securely and reliably.

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.




