How to change totals and details values in a Pivot Table

I

Igor R. Alcantara

I want to use the write back on my Pivot Table. What I need is change a
total value and the pivot table automatically changes the details and change
a detail line and automatically change the total. How can I do that?

Another question: how can I get what the double click in a cell and its
value?

Thanks,

Igor.
 
L

Luzzifuge

Actually what I need is to change the value of a specif cell, but th
Value property is read-only. How can I do that
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Excel does not accept text format! 0
Change a value in a pivot table cell 6
Pivot table 0
sqlite-odbc write conflict 2
Turning off automatic calculation 0
Auto populate value from one task to another in MS PROJECT 0

Top