Expand Pivot Tables without overwriting existing data beneath or to the right of table
With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?
Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?
It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table without overwriting the data beneath. Yet, it will fill in any blank rows first before shifting down the data rows beneath the table.
Given the many requests for this option, we are surprised that Microsoft has not responded to this request.
likewise for columns - i often have formulas following the table for further processing, and my kludgy work around is to always leave at least one blank column, which means that visually the related formulas are separated from the pivot data.
LG DES commented
This feature would avoid Refresh Data error: "PivotTable report cannot overlap another PivotTable"