• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Automatically Refresh Pivot Table Data

How to Automatically Refresh Pivot Table Data

By: Waseem Patwegar

Whenever you make changes to Source Data, it is important to make sure that Pivot Table is refreshed. You will find below the steps to Automatically Refresh Pivot Table Data and also the steps to Manually Refresh Pivot Table Data.

Automatically Refresh Pivot Table Data

Refresh Pivot Table Data

By default, Pivot Tables in Excel are not set to be automatically refreshed. However, it is possible to make a Pivot Table to automatically refresh its data by going to PivotTable options.

Whenever, a Pivot Table is set to refresh its data, it will automatically refresh its data, every time the worksheet containing the Pivot Table is opened.

If you are dealing with large amounts of data, the automatic data refresh option can slow down things.

Hence, it is better to manually refresh Pivot Table Data, in case of larger worksheets.

1. Automatically Refresh Pivot Table Data

You can follow the steps below to set 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

If you are dealing with a large Source Data, it is better to manually refresh Pivot Table and make sure that changes made in the Source Data are reflected in the Pivot Table.

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

Manually Refresh Pivot Table

Another way of 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

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

Prevent Column Widths and Cell Formatting From Adjusting

When you refresh Pivot Table, you may find column widths and cell formatting changing. 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 Autofit Column widths on update options.

Preserve cell Formatting in PivotTable on Update

3. Click on OK to preserve this setting.

After this, you won’t find the Pivot Table losing its cell formatting and column widths, whenever the Pivot Table data is refreshed.

Related
  • How to Change Pivot Table Data Source and Range
  • How to Hide Blanks in Pivot Table

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved