• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Change Pivot Table Data Source and Range

How to Change Pivot Table Data Source and Range

By: Waseem Patwegar

Depending on the type of change in the Source Data used for Pivot Table, you may find the need to either Change Pivot Table Data Source or simply Change Pivot Table Range.

Change Pivot Table Data Source and Range

Change Pivot Table Data Source and Range

In most cases, it is common to add more Rows in the Source Data to accommodate new records or entries.

Similarly, you may also find the need to totally reorganize the Source Data by adding new Data Rows and New Data Columns.

If this happens, you will have to change Pivot Table Data Range to include the newly added columns and rows in the Source Data.

However, if the Source Data arrives in a new worksheet, you will find the need to change Pivot Table Data source from old to New Spreadsheet.

1. Change Pivot Table Data Range

Whenever new Rows or Columns are added to Source Data, you can follow the steps below to Change Pivot Table Data Range.

1. Click on any Cell in the Pivot Table and this will bring up “Analyze” and “Design” Tabs in the top menu bar.

2. Next, click on Analyze tab > Change Data Source > Change Data Source… option in the drop-down menu.

Change Pivot Table Source Data

3. In Change Pivot Table Data Source dialogue box that appears, click in Table/Range box and select the entire Data Range (including new Rows & Columns) that you want to include.

Change Pivot Table Data Range

3. Click on OK to save the changes.

2. Change Pivot Table Data Source Worksheet

If the Source Data for Pivot Table has arrived in a new worksheet, you can follow the steps below to change Pivot Table Data Source.

1. Click on any Cell in the Pivot Table and this will bring up “Design” and “Analyze” tabs in the top menu bar.

2. Click on Analyze > Change Data Source > Change Data Source option in the drop-down menu.

Change Pivot Table Source Data

3. In Pivot Table Data Source dialogue box that appears, click in Table/Range box and click on the Worksheet containing new Source Data.

Change Pivot Table Data Source to New Worksheet

As you can see in above image, the “Table/Range” field refers to “Sales Jan” worksheet and clicking on “Sales Feb” will change Data Source for Pivot Table to the new worksheet.

After changing Data Source, make sure that Data Range includes all the rows and columns that need to be incorporated in the Pivot Table.

4. Click on OK to save the changes.

Related
  • How to Add or Remove Subtotals in Pivot Table
  • 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



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • Chromebook vs Windows Laptop
  • 12 Reasons to Switch to Chromebook
  • Kindle E-Reader Comparison
  • Best Asus Laptops Under 500




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved