Hey guys,
I have a problem with the formatting on pivot tables.
Here's the issue.
I have a pivot table that is connected to a view in a SQL database.
That table has user names in rows.
I applied formatting of my own to all of the pivot table (like inner and outer gridlines).
The problem is whenever I open the excel , connect to the view again and refresh the data i have issues with formatting.
Such as, letīs say I have a new user called Peter. He is added to the the table as the last row, like after Andy despite the column having sort from A-Z activated.
The other issue is this new user and all the data inherent to him are not formatted accordingly (no inner or outer borders around its cells).
I have "Preserve cell formatting on update" option of the pivot table turned on but this still happens.
Can anybody help me?
Is this possible to solve?
Thank you in advance
Bookmarks