You can't change or create a pivot table or pivot chart in a shared
workbook. Perhaps you could create the pivot table and pivot chart in a
different workbook (non-shared), based on the data in the shared workbook.

For more information on shared workbooks, look in Excel's Help, under
the topic 'Features that are unavailable in shared workbooks' or view
the list at the Microsoft site:

Features that are unavailable in shared workbooks
http://office.microsoft.com/en-ca/as...010801033.aspx


J Owen wrote:
I have created a pivot table for a shared worksheet. When a user tries to
change one of the parameters to filter the table, the sheet deactivates.
This happens as soon as the user clicks on the dropdown arrow. If the user
clicks a different item in the taskbar and then clicks on the spread sheet,
the dropdown list appears and he/she can continue working until they make
another change on the table.

Help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html