Worksheet linked to Pivot Table - Automatically Insert Rows

Tobor1

New Member
Joined
Oct 24, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I'm using Excel in Office 365. I have a worksheet linked to a Pivot Table in the same workbook. The worksheet is linked via cell references on the pivot table table. Here's the problem: Whenever new rows of data are added to the pivot table, the worksheet does not automatically update with these new rows. I have to go to the worksheet and manually drag down the formulas so they reference the new pivot table rows. This happens in reverse when rows are deleted from the pivot table. I have to manually delete rows on the worksheet so they match the pivot table.

Example: 1) The pivot table contains 10 rows and the linked spreadsheet shows those 10 rows. 2) The pivot table is refreshed and now has 20 rows, but the linked spreadsheet still only shows 10 linked rows. 3)Then I have to go to the worksheet and manually change the cell references to include the 10 new rows from the pivot table.

Is there a way to have my data on the linked worksheet automatically adjust for changes in the number of rows on the Pivot table? Thanks for your help
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,123,517
Messages
5,602,127
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top