• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iPhone
  • Mac
  • Web Services

How to Automatically Refresh Pivot Table Data

By: Sam Patwegar | Updated: November 16, 2026

While the default option in Microsoft Excel is to allow users to manually refresh the Pivot Table, it also provides the option to set the Pivot Table to automatically refresh its data. This can ensure that the Pivot Table is displaying updated data, when changes are made in the data source linked to the Pivot Table.

However, you need to be aware that setting up a Pivot Table to automatically refresh its data can considerably slow down things, if the Pivot Table is linked to a large data source or multiple data sources.

Related: How to Change Pivot Table Data Source and Range.

Advertisement

Refresh Pivot Table Automatically & Manually

You can find below the steps to refresh a Pivot Table automatically, manually and also the steps to prevent the column widths and cell formatting from being impacted, when a Pivot Table is refreshed.

1. Automatically Refresh Pivot Table Data

You can follow the steps below to setup a Pivot Table to Automatically Refresh its Data

1. Right-click anywhere on the Pivot Table and click on PivotTable Options in the menu that appears.

Open PivotTable Options

2. On PivotTable Options screen, click on the Data Tab and select Refresh data when opening the file option.

Refresh Pivot Table Data When Opening The File

3. Click on the OK button to save this change.

After this setting, you will find the Pivot Table refreshing its Data automatically, every-time you open the file containing Pivot Table.

2. Manually Refresh Pivot Table Data

You can use of any of these methods to Refresh Pivot Table Data and make sure that changes made in Source Data are reflected in the Pivot Table.

Method-1: Right-click anywhere on the Pivot Table and click on Refresh in the menu that appears.

Manually Refresh Pivot Table

Method-2: Another way to Manually Refresh Pivot Table is to click on the Analyze Tab in the top menu bar and click on Refresh option in the Data section.

Refresh Pivot Table Data

Prevent Column Widths and Cell Formatting From Adjusting

When you refresh Pivot Table, you may find column widths and cell formatting being changed. You can prevent this from happening by choosing “Preserve Cell Formatting” option in Pivot Table Options.

1. Right-click anywhere on the Pivot Table and click on PivotTable Options… in the menu that appears.

Open PivotTable Options

2. On PivotTable Options screen, click on Layout & Format and select Preserve cell formatting on update and Auto-fit Column widths on update options.

Preserve cell Formatting in PivotTable on Update

3. Click on OK to preserve this setting.

After this, you will not find the Pivot Table losing its cell formatting and column widths, whenever the Pivot Table is refreshed.

Sam Patwegar

10+ years experience in writing fluff-free troubleshooting guides with just the right and required amount of related information. Equally capable of In-depth technical writing.

Explor More!
  • Fix: Empty Cells and Error Values in Pivot Table
  • How to Change Pivot Table Data Source and Range
  • Fix: Microphone Not Working in Microsoft Teams

Primary Sidebar

Advertisement



Recent Posts

  • Fix: Start Menu Not Working in Windows 11/10
  • How to Set Sleep Timer in YouTube on iPhone
  • How to Change Text Size On iPhone
  • How to Download All Photos From iCloud to Mac
  • Fix: Duplicate Photos Not Showing on iPhone
Advertisement



© 2026 Techbout.com · All Rights Reserved
About | Privacy Policy | Terms | Contact
Twitter(X) | Facebook