Incorrect sort sticking

Question

Hello,

My boss opens the shared excel file and it is sorted in a way someone sorted it a while back, it is not in the normal default view we all see. Why is this old sort sticking in her computer? How can we get rid of it?

Answer 1

Dear Julie Biesiada

It's possible that the sorting settings were saved in a custom view or filter. To remove the sorting, you can try the following steps:

1. Open the Excel file and select the data range that is sorted.
2. Click on the "Data" tab in the ribbon.
3. Click on the "Sort & Filter" button and select "Clear".
4. If the sorting is still present, try removing any custom views or filters that may be applied. To do this, click on the "View" tab in the ribbon and select "Custom Views". From there, you can delete any custom views that may be affecting the sorting.

If the issue persists, you can try resetting the Excel settings to their default values. To do this, close all Excel files and open the "Run" dialog box by pressing the Windows key + R. Type "excel.exe /resetuserdata" and press Enter. This will reset all Excel settings to their default values.

Regards,

Stacey