Link to home
Start Free TrialLog in
Avatar of nrizvi110
nrizvi110

asked on

Excel Pivot Tables

Hello,

I have a pivot table connected to external data.  The report also includes data below the pivot table.  Everytime the pivot table is queried or refreshed, the number of rows below the pivot table needs to be manually adjusted to prevent the data outside the pivot to be overwritten, or not to have too many empty rows below the pivot table.  Any automation possible here?
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

I would recommend that you redo the report layout, so that those additional rows appear above the PivotTable.
ASKER CERTIFIED SOLUTION
Avatar of KristianB
KristianB
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial