Random Borders in Pivot Table Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2631658%22%20slang%3D%22en-US%22%3ERandom%20Borders%20in%20Pivot%20Table%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2631658%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20multiple%20pivot%20tables%20on%20a%20TAB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethey%20all%20run%20from%20same%20data%20and%20the%20filter%20for%20all%20of%20them%20is%20Slicer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20made%20sure%20all%20pivots%20have%20same%20design%20(no%20borders)%20%2C%20I've%20even%20selected%20the%20entire%20page%20and%20removed%20all%20borders%20from%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20use%20the%20slicer%20and%20move%20from%20one%20filter%20to%20another%20random%20borders%20appear%20around%20cells%20.%20Pivots%20work%20fie%2C%20it%20just%20makes%20them%20all%20look%20untidy%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20bit%20lost%20as%20to%20why%20it%20keeps%20doing%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20all%20have%20preserve%20formatting%20selected%20and%20autoresize%20unselected%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2631658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2631794%22%20slang%3D%22en-US%22%3ERe%3A%20Random%20Borders%20in%20Pivot%20Table%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2631794%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F534282%22%20target%3D%22_blank%22%3E%40shotgun-68%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CEM%3EHowever%2C%20when%20I%20use%20the%20slicer%20and%20move%20from%20one%20filter%20to%20another%20random%20borders%20appear%20around%20cells%20.%20Pivots%20work%20fie%2C%20it%20just%20makes%20them%20all%20look%20untidy%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20they%20really%20%3CSTRONG%3Erandom%3C%2FSTRONG%3E%3F%20Is%20there%20any%20relationship%20between%20the%20slicer%20used%20and%20the%20cells%20that%20display%20borders%3F%20It's%20just%20a%20hypothesis%20on%20my%20part%2C%20but%20something%20I'd%20want%20to%20check%20out%20if%20I%20were%20in%20your%20shoes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20you%20to%20attach%20a%20copy%20of%20the%20workbook%2Fspreadsheet%20in%20question%20or%20does%20it%20contain%20information%20that%20needs%20to%20be%20kept%20confidential%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I have multiple pivot tables on a TAB.

 

they all run from same data and the filter for all of them is Slicer

 

I've made sure all pivots have same design (no borders) , I've even selected the entire page and removed all borders from cells

 

However, when I use the slicer and move from one filter to another random borders appear around cells . Pivots work fie, it just makes them all look untidy 

 

I am a bit lost as to why it keeps doing this

 

They all have preserve formatting selected and autoresize unselected 

1 Reply

@shotgun-68 

 

However, when I use the slicer and move from one filter to another random borders appear around cells . Pivots work fie, it just makes them all look untidy 

 

Are they really random? Is there any relationship between the slicer used and the cells that display borders? It's just a hypothesis on my part, but something I'd want to check out if I were in your shoes.

 

Is it possible for you to attach a copy of the workbook/spreadsheet in question or does it contain information that needs to be kept confidential?