|
| 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
November 18th, 2005, 09:08 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
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
November 18th, 2005, 05:40 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
November 19th, 2005, 08:33 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
November 20th, 2005, 08:54 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
December 19th, 2005, 09:12 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
Linear Mode
