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.

EED wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html