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.