View original (French)

Insert additional row in pivot table

DJ -  
Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   -
Hello,

Hello;
I can't manage to add an additional row to my pivot table; I have a table with 5 rows and I would like to add a sixth one. How should I proceed to do that?
Kind regards, Jean
PS: I am working on Excel 2013

Kind regards, Jean

2 answers

Answer 1 / 2
Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 638
 
You cannot add rows in a PivotTable. To do that, you need to add a new reference to the source table and regenerate the PivotTable.

--
Remember remember the fifth of November
Gunpowder, treason and plot.
I see no reason why gunpowder, treason
Should ever be forgot...
0