Cannot chage this part of a PivotTable

[CrazyManiac]

Everytime I want to edit data in my Pivot Table I get this message:
"Cannot change this part of a PivotTable".

How can I allow to edit data field values in a Pivot Table using VBA?

 

[KenWright]

Well typically you don't. The Pivot table outputs a report based on the underlying data in your source data table, so any changes needed should be done at source and then simply refresh the table.

What exactly are you trying to do?

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[suiliclic]

Typically you can't change anything on a Pivot table. Unless you select the whole table and do Copy & Paste Special to a Value.

Zabrina from the SF BayARea
Just another humble analyst & VBA newbie~