Refresh pivot table on a Shared workbook

[Guest]

I'm running into an issue with my pivot table. This is a shared workbook for
a few people to enter data. I have 4 different sheets with pivot tables that
refer to other sheets in the workbook. I have the refresh on open selected,
but after I share this, nothing will refresh and havent figured out how to do
this or if possible? Thanks!

 

[Debra Dalgleish]

In a shared workbook, you can view existing pivot tables, but you can't
create a new one, or change an existing one.

Perhaps you could build the pivot table in a different workbook, linked
to the data in the shared workbook.