ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table and Shared Workbook (https://www.excelbanter.com/excel-worksheet-functions/136472-pivot-table-shared-workbook.html)

Joe Gieder

Pivot Table and Shared Workbook
 
Is there a way to update a pivot table in a shared worksheet without
unsharing then updateing the pivot table and then putting the worksheeet back
in share mode? If so how can I do it? Or any other suggestions?

Thank you again for your help
Joe

Debra Dalgleish

Pivot Table and Shared Workbook
 
You can view a pivot table in a shared workbook, but you can't refresh
or change it in shared mode.

Joe Gieder wrote:
Is there a way to update a pivot table in a shared worksheet without
unsharing then updateing the pivot table and then putting the worksheeet back
in share mode? If so how can I do it? Or any other suggestions?

Thank you again for your help
Joe



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



All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com