Forum Discussion
Custom Table style corrupting for some users on file open
Kazi_N Can you upload a file with the styles applied to some dummy tables and slicers. I'm on a European Mac myself.
Riny_van_Eekelen Hello, thank you for offering to help.
I just uploaded a dummy file, with the macros removed and relative information replaced with "Test" or "Dummy".
My assumption is that on file open, you will get a corruption flag and notice for Excel to attempt to repair the file.
Attached is also what the layout and style should look like
Much appreciated--
Kazi_N I do get the "there is a problem with this file" dialogue box and I allow Excel to repair it. The log files indicate that there are problems with "Styles", but the repaired file looks pretty okay. Compared it to opening the file on a PC and that one does not have any problems. The slicer styles come out dark blue buttons on light blue background on the Mac where on the PC it's dark blue on white. Then, on the Quote sheet in the top left hand corner, the conditional format that whites-out some cells below "Employee count" on the PC, doesn't seem to work the same as the formatting colours changed. See screenshot taken on the Mac. Don't know what causes this. Never experience it before.
- Thank you for testing and providing screenshots.
The screenshot you provided is exactly how Mac users from EMEA/APAC see the file.
On your Mac, you will see the Table style has completely different rules/formatting values than the PC.
Even the conditional formatting rules get flipped, with no rational reasoning why.
Do you have any on the best approach on how to solve this matter? I'm trying to understand the XML file from the repair report log generated. All I can deduce is that there is any issue with either/or/all of the
-Styles
-SlicerCache
-Table stylesKazi_N As said, don't know what to about it. Sorry!