ExcelBanter - pivot table grid formatting problem after refresh

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - pivot table grid formatting problem after refresh (https://www.excelbanter.com/excel-programming/293858-pivot-table-grid-formatting-problem-after-refresh.html)

annie

pivot table grid formatting problem after refresh

I have problems with formatting in a pivot table after its refreshed. I saved the pivot table with table option preserve formatting, and removed all grid lines, but when I refresh, the grid line comes back. How to save the proper formatting?

All times are GMT +1. The time now is 03:43 PM.