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.

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

--
Ben Sullin

--
bsullin
-----------------------------------------------------------------------
bsullins's Profile: http://www.excelforum.com/member.php...nfo&userid=139
View this thread: http://www.excelforum.com/showthread.php?threadid=26442

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


-----Original Message-----

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

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

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

--
Ben Sullins


--
bsullins
---------------------------------------------------------
---------------
bsullins's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=1394
View this thread:
http://www.excelforum.com/showthread...hreadid=264420

.