I had problem that every Number had Turned To Accounting Format. I solved that by changing number format in Cell Style(it had accounting formats). But I still have one problem left. In all pivot tables accounting formats stayed. In each field with numbers I have euros, also on graphs every number is in euros. Even though source tables no longer have accounting formats! When I refresh pivot table nothing changes. When I make new pivot from the same source table I don’t have that problem. It seems like existing pivot table just updates values and not formats. Is there a way to solve this without recreating all the tables?
Please help.
I did not find the right solution from the Internet.
