Search code examples
excelsharepoint-2010web-partspivot-table

Sharepoint 2010 Excel Web Part displaying Pivot Table colors incorrectly

I have a Sharepoint 2010 site with an Excel Web Part being used to embed a pivot table into a page. When first set up yesterday it worked perfectly, exactly as expected. However, today one of the users clicked on the Row Labels filter button and all of the colors changed.

Above is the table is it appears in the Excel document, below is the table as it appears in Sharepoint.

https://i.sstatic.net/pVqGe.png

I have already tried the following fixes:

Uploaded a new copy of the excel document Changed the theme of the table in excel Deleted the web part from the page and recreated it

Nothing has worked.

Please help

Solution

  • We were able to resolve the problem by restarting the Excel Services component of Sharepoint 2010.