Allowing editing in a Pivot table

R

Ryggen

I have seen examples that you can edit the content in a
Pivot table. I want to use this functionality to
create "What if?" analysis. My problem is that I can't
find a way to "open" the Pivot table for editing, I
always receive the message: "You can't change this part
of a Pivot table report".

Is there a property I have to define?
 
C

curllion

NO,You can not changed it.But you can copy it to another sheet as "data",and
you can edit it in this sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top