Hi:
I am using Excel 2003 and I need to protect a worksheet, but allowing users
to interact with a OLAP Pivot Table... i mean with drillup/drilldown and
slice functionality
I try with the next code in my workbook
Private Sub Workbook_Open()
ActiveSheet.EnableSelection = xlNoRestrictions
ActiveSheet.EnablePivotTable = True
ActiveSheet.Protect Password:="ABC", UserInterfaceOnly:=True,
AllowFormattingCells:=True, AllowFormattingColumns:=True,
AllowFormattingRows:=True, AllowUsingPivotTables:=True
ActiveSheet.PivotTables("Table1").RefreshTable
End Sub
But, when i try to drill-down or drill-up over the Pivot Table... i get the
next message:
The Data Source in this PivotTable require a refresh..." or something like
that...
Any idea
Thanks
Rodrigo
Bookmarks