Hi there,

when I use the following code:

For Each pvtTable In ActiveWorkbook.Worksheets
(wkSheet.Name).PivotTables
With pvtTable
.PreserveFormatting = True
.RefreshTable
End With
Next pvtTable

The preserveformatting is crashing excel. I know this
because when I take it out it works.

Any ideas?
Grant.