Home |
Search |
Today's Posts |
#1
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
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
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
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
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |