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

  1.
    Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 639
     
    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