Borders with Pivot Tables

Is there anyway I can prevent pivot tables entering borders around cells?

Any help most appreciated

Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK

You may have to enable selection (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

On the PivotTable toolbar, choose PivotTable>Select>Entire table
On the Formatting toolbar, click the arrow at the right of
the borders button
Click the No Borders button (at the top left)

If the you find that the borders return after you refresh the pivot
table, you could record a macro as you refresh and reformat the pivot
table. Then, run that when you want to update.


Sarah Kingswell wrote:
> Is there anyway I can prevent pivot tables entering borders around cells?
>
> Any help most appreciated
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks that appears to have worked.

"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:4241A79E.5040900@contexturesXSPAM.com...
> Set the pivot table to preserve formatting:
> On the pivot toolbar, choose PivotTable>Table Options
> Add a check mark to 'Preserve formatting', click OK
> Remove the check mark from AutoFormat Table
> Click OK
>
> You may have to enable selection (From the Pivot toolbar, choose
> PivotTable>Select, and click on Enable Selection)
>
> On the PivotTable toolbar, choose PivotTable>Select>Entire table
> On the Formatting toolbar, click the arrow at the right of
> the borders button
> Click the No Borders button (at the top left)
>
> If the you find that the borders return after you refresh the pivot table,
> you could record a macro as you refresh and reformat the pivot table.
> Then, run that when you want to update.
>
>
> Sarah Kingswell wrote:
>> Is there anyway I can prevent pivot tables entering borders around cells?
>>
>> Any help most appreciated
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>