Pivot table borders

[Guest]

Is there a way to suppress the borders automatically coming up whenever a
pivot table is refreshed. I have used both tabular and outline format. But
whenever I refresh the table a default set of borders automatically appear. I
have turned on the preserve formatting in the Table options. Any ideas.

 

[Ken Wright]

Have you tried turning off Autoformat table in the Table options?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

Yes. I have tried with turning off the Autoformat table option as well to no
avail.

 

[Ken Wright]

Just tried myself and get the same as you. :-(

Not ideal I know, but another option would be to have a macro redo the
borders the way you want them. You can tie it to the following event and it
should run anytime you refresh your table:-

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Your_Code
End Sub

Regards
Ken..................

 

[Marc]

I did a right click in the table and selected "format cells", then select
the "border" tab, select "presets none"--this should eliminate the border.

I clicked "refresh" several times and the borders did not reappear...