| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh pivot table on a Shared workbook
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh pivot table on a Shared workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i refresh a pivot table report in a shared file | Excel Discussion (Misc queries) | |||
| Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
| How to refresh the pivot table while the excel sheet in shared? | Excel Worksheet Functions | |||
| Pivot Table and Shared Workbook | Excel Worksheet Functions | |||
| Pivot Table in a Shared Workbook | Excel Discussion (Misc queries) | |||
Linear Mode
