Refreshing Pivot Tables in a Shared Workbook
 

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

Refreshing Pivot Tables in a Shared Workbook
 

Hi

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

--
Regards

Roger Govier


"Pedro" wrote in message
...
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