Page 1 of 1

Refresh pivot table

Posted: Wed Jan 22, 2014 5:27 pm
by CareAll
Hello,

I have pivot tables and before saving the file I'd like to refresh the content of the pivot tables programmatically.
Is there a way to achieve this?

Re: Refresh pivot table

Posted: Wed Jan 22, 2014 11:42 pm
by larsa
Hello

There is no direct interface to the pivot data, but it's stored in an XML DOM database, so it should not be too difficult to do that. Please send me a sample of your pivot file, and I can give you more details.

Re: Refresh pivot table

Posted: Thu Jan 23, 2014 12:24 am
by CareAll
E-mail sent containing sample file.