Others

How to Stop Excel from Automatically Sorting Data When Opened

Natalie TaylorNatalie Taylor Oct 19, 2026 871 views

Question details

The user needs to identify and stop Excel workbooks from automatically sorting or changing the order of rows upon opening.

How to Stop Excel from Automatically Sorting Data When Opened
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a shared or local Excel workbook containing tables, pivot tables, or external data connections.
Observed behavior
The Excel workbook automatically changes the order of rows or sorts data without manual input as soon as the file is opened.
Before you start

Before troubleshooting, check with your team to see if someone else saved a sorted version of the shared file, and temporarily disable your internet connection to rule out external data refreshes.

Solution 1Recommended

Disable Automatic Refresh for External Connections and Power Query

External data connections often refresh upon opening the file, causing data to re-sort based on the original data source.

If your workbook is connected to an external database or utilizes Power Query, it may be configured to fetch the latest data every time the file is opened. This refresh process can override any manual sorting you previously applied.

1
Navigate to the Data tab

Open your Excel workbook and click on the 'Data' tab in the top ribbon.

2
Open Queries & Connections

Click on 'Queries & Connections' to open the side pane displaying all active connections.

3
Access Connection Properties

Right-click your query or data connection in the side pane, and select 'Properties'.

4
Disable refresh on open

Under the Usage tab in the properties window, uncheck the box for 'Refresh data when opening the file' and click 'OK'.

Disable Automatic Refresh for External Connections and Power Query
Data Persistence: By disabling the automatic refresh, your manual sorting will remain exactly as you saved it. You can still refresh the data manually whenever needed.
Free Microsoft Office alternative

Experience Hassle-Free Data Management with WPS Office

If complex settings, hidden automations, and unexpected behaviors in Microsoft Excel are causing frustration, consider switching to WPS Office. It provides a clean, user-friendly interface for spreadsheet management without bloated background processes.

  1. 1. Download and Install: Download WPS Office Free from the official website and install the lightweight suite on your PC or Mac.
  2. 2. Open Your Excel File: Launch WPS Spreadsheet, click 'Open', and select your existing .xlsx workbook. It will load instantly.
  3. 3. Manage Data Seamlessly: Use the Data tab to manually apply sorts and filters exactly how you want them, without worrying about hidden automations.
Highly compatible with Microsoft Excel (.xlsx, .xls) formats and formulasLightweight architecture ensures files open quickly without unexpected automatic sortingIntuitive Data tab makes manual sorting, filtering, and analysis straightforwardCompletely free to use with a familiar interface for zero-learning-curve migration
microsoft office alternative - wps office

Frequently Asked Questions

Can conditional formatting cause my Excel file to sort automatically?

No, conditional formatting only changes the visual appearance of the data, such as altering the cell background color or font style based on specific rules. It does not physically change the order of rows or sort the data in your workbook.

Why is a shared Excel file opening with a completely different sort order?

In a shared environment like OneDrive, SharePoint, or a network drive, another user may have sorted the data and saved the file. When you open it, you see the state in which it was last saved. You can check the version history under File > Info to see who last modified the document.

How do I know if a third-party Excel Add-in is causing my data to sort?

You can test this by launching Excel in Safe Mode. Press and hold the Ctrl key while clicking the Excel shortcut, and confirm you want to start in Safe Mode. If the automatic sorting stops, an Add-in is likely the cause. You can then disable Add-ins one by one in File > Options > Add-ins to find the exact culprit.