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).