Hi,

I am exporting data to a worksheet "Data". The worksheet "Result" is based
on the worksheet "Data", and has a pivot table.

When my users open the workbook, the pivot table gets refreshed which
changes the state of the file to "modified". When they close the workbook,
they get a message "do you want to save the changes you have made?".

I think this message can be avoided if I can refresh the pivot table from
within the activex. How can I refresh the pivot table from the activex task?


--

Hello Black,

You could probably call into the Excel object model to do this. If you have
a Google no doubt you could find some code to do it.


http://groups.google.co.uk/groups?q=Script%20refresh%20Excel%20pivot%20tables&ie=UTF-8&oe=UTF-8&rls=org.mozilla:en-US:official&client=firefox-a&sa=N&tab=wg

Remember MS do not support Office automation unattended.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]