Change a PivotTable cell value

I

Igor R. Alcantara

I want to change the value of a cell in a Pivot Table programatically. What
methods can I use? How can I do that?
 
A

Alvin Bruney - ASP.NET MVP

I assume you need more than that - if this is the case, you should consider
downloading the Office web components toolpack from Microsoft. It's a free
download. It has helpful scripts and snippets to get you started for version
10. The toolpack may be used for version 11 although it isn't meant for that
version. If you need a more robust resource, try the black book.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET
 

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

Changing row background from external program 0
Excel does not accept text format! 0
Pivot Table cell values 1
Crating User Form to Add Names 1
Word macro that can call cells out of Excel for a find and replace 0
Dealing with a Pivot Table (when I don't want to) 0
#N/A values when exporting PivotTable to Excel 0
Excel - Wich Function should I use? 1

Top