Ed_CLP
asked on
PowerPoint with linked Excel PivotTable - not dynamically sizing
I have a PowerPoint that uses linked Excel PivotTables. The problem I'm having is that the PivotTables have a variable number of rows. If I insert/Link a table with 10 rows, the PowerPoint will only display the first 10 rows when the linked Excel data changes and now has 20 rows. If I insert/link the 20 row table then PowerPoint displays the blank rows when the data changes to a table with less than 20 rows.
I have not been able to suppress the cell borders on the empty rows or using the maximum table size would work (see attached image).
PivotScreenCapture.gif
I have not been able to suppress the cell borders on the empty rows or using the maximum table size would work (see attached image).
PivotScreenCapture.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No answers were submitted before I solved the problem.
ASKER