View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Ken Wright
 
Posts: n/a
Default Pivot table borders

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..................


"Suresh" wrote in message
...
Yes. I have tried with turning off the Autoformat table option as well to
no
avail.

"Ken Wright" wrote:

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 :-)
------------------------------*------------------------------*----------------


"Suresh" wrote in message
...
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.