Forum Discussion
Random Borders in Pivot Table Cells
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
3 Replies
I just had the same issue. For those looking for an answer, I was able to fix it by removing the impacted field from the pivot table and re-adding it.
- did you ever find a solution? I'm running into the same issue
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?
