Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update a pivot table on shared workbook
I have a few pivot tables on a shared workbook. I have it set to refresh
when the workbook is open, which that works until I Share the workbook. After its shared, it will no longer update/refresh. Is there a way to do this or possible? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update a pivot table on shared workbook
Sharing a workbook disables lots of features. If you look in Excel's help for:
Features that are unavailable in shared workbooks You'll see refreshing a pivottable is one of those features. EED wrote: I have a few pivot tables on a shared workbook. I have it set to refresh when the workbook is open, which that works until I Share the workbook. After its shared, it will no longer update/refresh. Is there a way to do this or possible? Thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update a pivot table on shared workbook
In a shared workbook, you can view existing pivot tables, but you can't
create a new one, or change or refresh an existing one. Perhaps you could build the pivot table in a different workbook, linked to the data in the shared workbook. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "EED" wrote: I have a few pivot tables on a shared workbook. I have it set to refresh when the workbook is open, which that works until I Share the workbook. After its shared, it will no longer update/refresh. Is there a way to do this or possible? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update a pivot table on shared workbook
OK, thanks....I'll probably place it in a different spreadsheet then. Thanks
thought! "Dave Peterson" wrote: Sharing a workbook disables lots of features. If you look in Excel's help for: Features that are unavailable in shared workbooks You'll see refreshing a pivottable is one of those features. EED wrote: I have a few pivot tables on a shared workbook. I have it set to refresh when the workbook is open, which that works until I Share the workbook. After its shared, it will no longer update/refresh. Is there a way to do this or possible? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and Shared Workbook | Excel Worksheet Functions | |||
update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Pivot Table in a Shared Workbook | Excel Discussion (Misc queries) | |||
Refresh pivot table on a Shared workbook | Excel Programming | |||
Update a shared workbook. | Excel Programming |