| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update pivot in shared shared workbook
I have a shared workbook with a data sheet on one tab and a pivot to that
data sheet on a separate tab. When I update the data, the pivot won't allow me to update it. Is there a work around? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
update pivot in shared shared workbook
If you look at "Features that are unavailable in shared workbooks" in Excel's
help, you'll see that this isn't supported. The only workaround I know is to unshare the workbook. 00George00 wrote: I have a shared workbook with a data sheet on one tab and a pivot to that data sheet on a separate tab. When I update the data, the pivot won't allow me to update it. Is there a work around? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook | Excel Discussion (Misc queries) | |||
| Excel Links Update | Links and Linking in Excel | |||
| Pivot Table in separate workbook | Excel Discussion (Misc queries) | |||
| using forms in a shared workbook | Excel Worksheet Functions | |||
| how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) | |||
Linear Mode
