I created a PowerPivot table. Below the table, I included a few rows of calculations (outside the table range). When I refresh the PowerPivot data source and table, if the number of rows within the table increases, my formulas below the table are overridden. Is there a way to instruct Excel to insert additional rows as needed, rather than overriding the data below the table?
Thanks!
Thanks!