Step-by-Step Guide: How to Perform a Quick Refresh on Your Excel Pivot Tables

Step-by-Step Guide: How to Perform a Quick Refresh on Your Excel Pivot Tables

Charles Lv12

Step-by-Step Guide: How to Perform a Quick Refresh on Your Excel Pivot Tables

Using a pivot table, you can analyze large amounts of data easily. But as we all know, data can and often does change. To make sure that your data is current, here’s how to refresh a pivot table in Excel .

Whether the data in your pivot table comes from an external source or the same workbook, you can update it manually or automatically. You can also adjust a setting so that the formatting doesn’t change when you update the table.

Refresh a Pivot Table Manually

If you would prefer to update your pivot table manually when needed, start by selecting the table.

Go to the PivotTable Analyze tab that appears. Click the Refresh drop-down arrow in the Data section of the ribbon.

To refresh the selected pivot table, choose “Refresh.” To refresh all pivot tables in your workbook, choose “Refresh All.”

Refresh or Refresh All for a pivot table

Alternatively, you can right-click the pivot table and choose “Refresh” in the shortcut menu.

Refresh in the shortcut menu

If the update takes a bit of time, you can select Refresh > Refresh Status to see the progress. To cancel, choose Refresh > Cancel Refresh.

Kanto Player Professional

Refresh a Pivot Table Automatically

Maybe you’d rather that your pivot table update each time you open the workbook. This is a good way to always have refreshed data and saves you from remembering to manually update the table.

Related: What are Pivot Tables in Google Sheets, and How Do I Use Them

Select the pivot table and go to the PivotTable Analyze tab. On the left side, use the PivotTable drop-down arrow and click Options > Options.

Open the pivot table Options

Glarysoft File Recovery Pro Annually - Helps to recover your lost file/data, even permanently deleted data.

In the PivotTable Options window, select the Data tab. Then, check the box for Refresh Data When Opening the File. Click “OK.”

Refresh when opening the file

Easy GIF Animator is a powerful animated GIF editor and the top tool for creating animated pictures, banners, buttons and GIF videos. You get extensive animation editing features, animation effects, unmatched image quality and optimization for the web. No other GIF animation software matches our features and ease of use, that’s why Easy GIF Animator is so popular.

BLUETTI NEW LAUNCH AC180T

Prevent Formatting Changes Upon Update

Sometimes the data that gets updated is wider than your column width or longer than your row height. If you want to retain the formatting for your columns and rows when you refresh a pivot table, it’s a simple setting.

Related: How to Set Row Height and Column Width in Excel Using the Keyboard

Select the pivot table and go to the PivotTable Analyze tab. On the left side, use the PivotTable drop-down arrow and then click Options > Options.

In the PivotTable Options window, select the Layout & Format tab. Then, check the box for Preserve Cell Formatting on Update. Optionally, you can check the box directly above for Autofit Column Widths on Update. Click “OK.”

Preserve pivot table formatting

Keep your data current and up to date by refreshing your pivot table in Excel, either manually or automatically.

Related: How to Use Pivot Tables to Analyze Excel Data

  • Title: Step-by-Step Guide: How to Perform a Quick Refresh on Your Excel Pivot Tables
  • Author: Charles
  • Created at : 2024-08-28 04:34:42
  • Updated at : 2024-08-29 04:34:42
  • Link: https://win-amazing.techidaily.com/step-by-step-guide-how-to-perform-a-quick-refresh-on-your-excel-pivot-tables/
  • License: This work is licensed under CC BY-NC-SA 4.0.