Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PivotTable
Hi all,
sorry for my bad englisch . I have questation about pivot table . I want restrict user to access column with text.If I protect document , refresh not enable . why I restrict user ? thanx marek |
#2
|
|||
|
|||
you can record a macro as you unprotect the sheet, refresh, then
reprotect. In the recorded code, you can add a password, e.g.: '========================== Sub RefreshPivot() ActiveSheet.Unprotect Password:="MyPwd" ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh ActiveSheet.Protect Password:="MyPwd", _ DrawingObjects:=True, Contents:=True, _ Scenarios:=True, AllowUsingPivotTables:=True End Sub '======================= Then, add a "Refresh" button to the worksheet, and assign that macro to the button. Marek G wrote: Hi all, sorry for my bad englisch . I have questation about pivot table . I want restrict user to access column with text.If I protect document , refresh not enable . why I restrict user ? thanx marek -- 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 | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) | |||
Pivottable Dates | Excel Discussion (Misc queries) | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
pivottable - show all not appearing | Excel Worksheet Functions |