Excel pivot table don't preserve formating after update or expanding and collpsing a group

Question

Hi,

I have several pivot tables that are connected to our database. when I change the cell color or formating and then update / refresh the pivote tible all the colors / formating disapear. please note that the option "Preserve cell formatting on cell update" is already on.

Can you help me fix this issue.

Thank you very much

Regards

Nidal Koudsy

Answer 1

Hi @Nidal Koudsy,

How did you format the PivotTable in Excel?

PivotTable cannot save custom cell formats, you need to create the custom PivotTable style and apply it for PivotTable.

I suggest you refer to this support article to get more information:

https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.