Pivot table borders
 

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.

Pivot table borders
 

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.

Pivot table borders
 

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.

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.

Pivot table borders
 

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