Pivot Table formatting after refresh

I've struggled with this same issue and found a possible solution: be sure to apply formatting to cells and not entire columns. When I, say, select columns and format to currency, refreshing removes the formatting. When I selecting just the cells with data in those columns and formatting to currency, then the formatting stays. (Before doing this, I also unchecked and rechecked the keep formatting option.)