Selecting columns for pivot table

**James1977** · 07-24-2009, 07:25 AM

Hi Palmetto

Thank you very much for getting back to me. The problem I will have though is that all the columns will show in my pivot table field list i.e. be available as options to select from which I don't want them to be. Does this make sense?

**Palmetto** · 07-24-2009, 07:46 AM

OK. I see what you mean now.
There is no way that I am aware of to hide items in the field list. I think you will have to work with a subset of the data that excludes the columns you dont want them to access.

But this may not be feasible if those columns contain data needed for calculations in the the Pivot Table.

**DonkeyOte** · 07-24-2009, 07:58 AM

Once the PT is setup you can apply code such that the Field List is Disabled when PT first updated (refreshed etc...) - the same can be done with the PT Wizard which pre-07 could be used to alter the layout also, eg:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Application.EnableEvents = False
With Target
    .EnableFieldList = False
    .EnableWizard = False
End With
Application.EnableEvents = True
End Sub

Not sure if this is what you want or not... obviously you could add Admin functionality such that Boolean Enabled status is dependent say upon Environ("username") being = to your own credentials (ie if you (true) then features enabled else (False) they are disabled)