View original (French)

Freeze column values in a Pivot Table

loikik Posted messages 1 Status Member -  
Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   -
Hello,

In my pivot table, is it possible to "freeze" values in a column at a specific moment so that when I refresh the data next time, the data in that column doesn't change?

Thank you for your help =)

1 answer

  1.
    Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    No.

    --
    Retirement is nice! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0
    1. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
       
      ... but you can try to "freeze" those values in the data table from which the pivot table is inserted.
      0