Preserve Formatting crashing excel

[Grant]

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.

 

[bsullins]

This sounds crazy but i think the Preserve Formatting function is cas
sensative...

I tried it and this worked, hope it helps...

For Each pvtTable I
ActiveWorkbook.Worksheets("sheet4").PivotTables
With pvtTable
.preserveformatting = False
.RefreshTable
End With
Next pvtTable

 

[Grant]

Hmm must be something else, because it still didn't work
for me.