---
title: "How to stop automatic sorting in pivot tables in excel?"  
description: "How to stop automatic sorting in pivot tables in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96522/how-to-stop-automatic-sorting-in-pivot-tables-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 1 minute  

---

# How to stop automatic sorting in pivot tables in excel?

How to stop [automatic](https://www.mindstick.com/interview/2449/what-is-automatic-reference-counting-arc) [sorting](https://www.mindstick.com/articles/1581/sorting-list-with-side-bar) in [pivot](https://www.mindstick.com/articles/1511/pivot-with-dynamic-columns-in-sql-server) [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in excel?

## Answers

### Answer by Hitesh Vohra

**The following steps will show you how to disable auto sorting and formatting in a pivot table.**

- We have a pivot table like the one below, and we don't want it to execute auto sorting when it's refreshed.
- We can easily accomplish this by using the Sort option in the **Pivot table Options.**
- Right-click on the pivot table and select **Sort->More Sort Options.**
- You'll see a window box similar to the one below, and then **click More Options.**
- To stop auto sort in pivot table after refresh, uncheck the 'Sort automatically every time the report is updated' option in the window box shown below and hit OK. When you refresh the pivot table in [**Excel**](https://answers.mindstick.com/qa/96538/how-can-you-apply-the-same-formatting-to-every-sheet-in-a-workbook-in-ms-excel) after removing this option, it will no longer auto sort.

\

**Read More:** [**What is vlookup function in excel?**](https://answers.mindstick.com/qa/96524/what-is-vlookup-function-in-excel)

\


---

Original Source: https://answers.mindstick.com/qa/96522/how-to-stop-automatic-sorting-in-pivot-tables-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.