EnableRefresh Property Example

This example sets the first PivotTable report on worksheet one so that it cannot be refreshed.

Worksheets(1).PivotTables("Pivot1") _
    .PivotCache.EnableRefresh = False