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