How do you unlock a pivot table on a protected excel sheet?

I have a protected worksheet with only input cells unlocked. A pivot table
was created to analyze data, however when I protect the worksheet it does not
allow the ordinary user the ability to refresh the pivot table data?

Is it possible to protect the worksheet and still allow other users to
refresh the pivot table?

You can do it with code by putting a button on the sheet to unprotect,
refresh and reprotect, something like
Sub Refresh()
ActiveSheet.Unprotect ("Password")
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveSheet.Protect ("Password")
End Sub
Please post back if you're unfamiliar with VBA code,
Regards,
Alan.
"billseals@yahoo.com" <billseals@yahoo.com@discussions.microsoft.com> wrote
in message news:370E1DE7-6E1E-4D0C-8DA8-F4F8ADE0660D@microsoft.com...
>I have a protected worksheet with only input cells unlocked. A pivot table
> was created to analyze data, however when I protect the worksheet it does
> not
> allow the ordinary user the ability to refresh the pivot table data?
>
> Is it possible to protect the worksheet and still allow other users to
> refresh the pivot table?

I can follow the code and if it is correct in syntax accomplish it. However
it has been a long time since I done much programming.

"Alan" wrote:

> You can do it with code by putting a button on the sheet to unprotect,
> refresh and reprotect, something like
> Sub Refresh()
> ActiveSheet.Unprotect ("Password")
> ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
> ActiveSheet.Protect ("Password")
> End Sub
> Please post back if you're unfamiliar with VBA code,
> Regards,
> Alan.
> "billseals@yahoo.com" <billseals@yahoo.com@discussions.microsoft.com> wrote
> in message news:370E1DE7-6E1E-4D0C-8DA8-F4F8ADE0660D@microsoft.com...
> >I have a protected worksheet with only input cells unlocked. A pivot table
> > was created to analyze data, however when I protect the worksheet it does
> > not
> > allow the ordinary user the ability to refresh the pivot table data?
> >
> > Is it possible to protect the worksheet and still allow other users to
> > refresh the pivot table?
>
>
>