Every time I refresh my Pivot tables, Excel re-formats the Boarders on the
entire worksheet. The boarder pattern seems to be completely random. I have
gone thru every trouble shoot and training section I can find, no help to me.

How can I turn off the automatic boarder?

I have tried refreshing the data without any formatting and still have this
same problem.

Every time I refresh the data I have to reformat the entire worksheet. It's
fine now, but my pivot table is becoming very large.

I am using Excel 2007