Excel Pivot Table: Hide Drop-Down Arrow button from all pivot fields

You will need to make a copy of the formatting and data to an alternate location. VBA something like the following will do this:

    Dim PivotTable As PivotTable
    Set PivotTable = Sheets("Sheet1").PivotTables("PivotTable1")
    PivotTable.TableRange1.Copy
    Sheets("Sheet2").[A1].PasteSpecial xlPasteValuesAndNumberFormats

You can run this code everytime the pivot table changes.

Kevin

Thanks for the quick reply Kevin, I really need to have the controls disabled because I am dealing with a large number of pivot tables (at least 16), one table per tab.  Believe this will add more complexity and replicated tables?

Rgds,

Yes, it will. But you may not have any other choice. By default a pivot table implies user control over how the data is displayed and hence the drop down menu controls. If you were somehow able to prevent those controls from displaying then it wouldn't be a pivot table.

Kevin

I do understand the dynamic nature of pivots and cubes, I thank you for your input.  Will wait till someone shows me how to hide the drop-down controls.

Ohhhhh YEAH!!
That's exactly what I was talking about - Thank you so much.  You rock!

:)