Forum Discussion
Custom Table style corrupting for some users on file open
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!
Riny_van_Eekelen After some more investigation, I figured out the root of the issue is the region settings of Mac users.
United States/Americas region will open just fine. Once I switch to a different region outside US and open the same file, I get the corruption notice. This makes me guess that there must be an issue with the custom currency formats I have.
Do you have any tips/guidance on how to make my currency formats compatible internationally?