If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot table | rmsterling | General Discussion | 5 | November 14th, 2005 04:40 PM |
Change Data In Pivot Table | John Calder | New Users | 1 | July 7th, 2005 10:41 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |