Refreshing Pivot Tables in a Shared Workbook

[Pedro]

Until the momment have been imposible to me develop some code (associated to
any event or button) that allow me to refresh a pivot table if I am sharing
that workbook.
Could someone help me????, I will really appreciate that help.

I already think in the possibilitie of unshare and share again the workbook
using an event but that solution will not work due to the fact that if users
are working at this point in time you have to disregard its changes just to
get a refresh and what you want to see is the reflexion of the changes that
they are mading then you can't disregard its changes.

Thanks, and if nobody know a solution feel free to advice microsoft to
improve that point because all the power of pivot tables is been loosing in
this condition (shared workbook combined with Pivot tables)

Regards, Pedro

 

[Roger Govier]

Hi

I believe refreshing of Pivot Tables is one of the things that will not
work in a shared workbook scenario.