Pivot table borders

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 :-)
------------------------------­------------------------------­----------------
 
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..................
 
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...
 
Back
Top