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