SharePoint Document Issues

Fix Excel Sort Order Not Saving in SharePoint

WPS Editor Sep 30, 2026 868 views

Question details

The user needs to make their color-based sort order persist in an Excel workbook stored in SharePoint.

How to Fix Excel Sort Order Not Saving in SharePoint

Product: Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Sorting data in a shared workbook hosted on SharePoint or Excel for the Web.
Observed behavior: The sorting applied to the data is lost after refreshing or closing the file, failing to save back to SharePoint.

Before you start

Ensure you have the desktop version of Excel installed and that no other users are currently co-authoring or editing the same workbook, which can cause synchronization conflicts.

Solution 1Recommended

Apply and Save Sort Order Using the Excel Desktop App

Opening the file in the desktop app rather than Excel for the Web ensures advanced formatting and sorting rules are properly saved and synced.

Excel for the Web sometimes struggles to persist view changes like sorting, especially when co-authoring is active. Using the desktop application provides full functionality and ensures proper synchronization.

Open in Desktop App

Navigate to your file in SharePoint or Excel for the Web, then click on the 'Editing' dropdown or select 'Open in Desktop App' from the top ribbon menu.

Apply Sort Order

Once the workbook opens in the desktop application, select your data range and apply your desired color-based sort order from the 'Data' tab.

Save and Sync

Click the Save icon or press Ctrl + S. Wait for the sync icon in the title bar to confirm the changes have been successfully uploaded back to SharePoint.

Apply and Save Sort Order Using the Excel Desktop App

Synchronization Check: Close the file and reopen it in SharePoint to verify that the sort order has successfully persisted.

Solution 2

Download, Sort Locally, and Replace the File

If syncing directly from the desktop app fails due to SharePoint connectivity issues, downloading a local copy guarantees the changes can be saved.

Free Microsoft Office alternative

Try WPS Office for Reliable and Fast Spreadsheet Editing

If you frequently experience synchronization or formatting issues with Office for the Web, WPS Office provides a free, highly compatible, and lightweight desktop alternative. Enjoy robust spreadsheet tools without the lag or feature limitations of web-based editors.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheets and open your downloaded .xlsx file to edit locally without sync interruptions.
3. Apply Sorting Easily: Use the Data tab to easily apply custom or color-based sorting, which saves perfectly every time.

100% compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Robust sorting and filtering capabilities including color-based sortsLightweight desktop app with a familiar, easy-to-navigate interfaceCompletely free to download and use for your daily office needs

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for the Web lose my custom sorting?

Excel for the Web is optimized for lightweight editing and sometimes struggles to save complex or temporary views, such as color-based sorting, especially when multiple users are accessing the shared workbook simultaneously.

Can co-authoring affect how sorting is saved in SharePoint?

Yes. If another user is editing the workbook at the same time, their view or active changes might override or prevent your sort order from being saved as the default view for the file.

How do I save my sort order without affecting other users?

In Excel for the Web, you can navigate to the View tab and select 'New' under Sheet Views. This allows you to apply and save a custom sort order that only you can see, without disrupting the default view for other SharePoint users.

Document & File Issues