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.
--
Jason

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

I guess I misspoke. The workbook is not saved as a shared workbook. Only
saved on a network drive. It was working fine on my machine until today.
Now my window deactivates as well. Again, click on another application on
the task bar and come back to the workbook and the pivot table ddl is
available and works fine.
--
Jason


"Debra Dalgleish" wrote:

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