update pivot in shared shared workbook

0

00George00

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?
 
D

Dave Peterson

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