Aug 10 2021 04:51 AM
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
Aug 10 2021 05:26 AM
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?
Aug 04 2022 02:22 PM