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

.