Custom Table style corrupting for some users on file open

%3CLINGO-SUB%20id%3D%22lingo-sub-2863326%22%20slang%3D%22en-US%22%3ECustom%20Table%20style%20corrupting%20for%20some%20users%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2863326%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all--I'm%20at%20my%20wits%20end%20to%20this%20and%20have%20no%20clue%20what%20other%20solutions%20to%20try.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EContext%3A%3C%2FSTRONG%3E%20Organizational%20license%2C%20everyone%20has%20Excel%20365.%26nbsp%3B%3C%2FP%3E%3CP%3ECreated%20a%20new%20default%20style%20for%20Slicers%2Ftables%2Fpivottables.%3C%2FP%3E%3CP%3EWorks%20fine%20on%20my%20own%20device%20and%20other%20Mac%20devices.%20ONLY%20errors%20out%20on%20international%20Mac%20devices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20custom%20formatted%20PivotTables%2C%20slicers%2C%20and%20tables%20on%20my%20workbook%20model%20that%20follow%20my%20companies%20design%20theme.%20On%20file%20open%2C%20the%20formats%20appear%20fine%20on%20both%20my%20Windows%20and%20Mac%20devices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20my%20colleagues%20in%20EMEA%20%26amp%3B%20APAC%20open%20the%20file%2C%20they%20get%20a%20file%20corruption%20dialogue%20box%20and%20notice%20to%20repair%20Excel%20file.%20After%20repairing%2C%20all%20the%20styles%20are%20completely%20messed%20up.%3C%2FP%3E%3CP%3EWhere%20the%20table%20would%20have%20a%20header%20in%20blue%20fill%20%26amp%3B%20bold%20format%2C%20is%20now%20instead%20showing%20every%20other%20row%20with%20that%20format%20and%20all%20white%20font.%20I%20never%20set%20that%20style%2C%20however%20if%20I%20investigate%20the%20faulty%20spreadsheet%2C%20it%20will%20show%20that%20as%20the%20set%20style.%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20appears%20that%20the%20custom%20table%2Fslicer%2Fpivottable%20style%20is%20not%20being%20recognized%20on%20specifically%20Mac%20devices%2C%20outside%20of%20North%20America.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESolutions%20tried%20so%20far%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E1.%20Using%20Inquire%20add%20in%20to%20clean%20excess%20formatting.%20Doesn't%20seem%20to%20do%20anything%3C%2FP%3E%3CP%3E2.%20Using%20XLStyles%20tool%20to%20investigate%20file%20and%20process.%20No%20dice.%3C%2FP%3E%3CP%3E3.%20Removing%20custom%20formats%20all%20throughout%2C%20however%20can't%20seem%20to%20fully%20eradicate%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20guidance%20or%20solutions%20would%20be%20greatly%20appreciated--%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2863326%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2863937%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Table%20style%20corrupting%20for%20some%20users%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2863937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751700%22%20target%3D%22_blank%22%3E%40Kazi_N%3C%2FA%3E%26nbsp%3BCan%20you%20upload%20a%20file%20with%20the%20styles%20applied%20to%20some%20dummy%20tables%20and%20slicers.%20I'm%20on%20a%20European%20Mac%20myself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2864070%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Table%20style%20corrupting%20for%20some%20users%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BHello%2C%20thank%20you%20for%20offering%20to%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20uploaded%20a%20dummy%20file%2C%20with%20the%20macros%20removed%20and%20relative%20information%20replaced%20with%20%22Test%22%20or%20%22Dummy%22.%3C%2FP%3E%3CP%3EMy%20assumption%20is%20that%20on%20file%20open%2C%20you%20will%20get%20a%20corruption%20flag%20and%20notice%20for%20Excel%20to%20attempt%20to%20repair%20the%20file.%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20also%20what%20the%20layout%20and%20style%20should%20look%20like%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20appreciated--%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2864235%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Table%20style%20corrupting%20for%20some%20users%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751700%22%20target%3D%22_blank%22%3E%40Kazi_N%3C%2FA%3E%26nbsp%3BI%20do%20get%20the%20%22there%20is%20a%20problem%20with%20this%20file%22%20dialogue%20box%20and%20I%20allow%20Excel%20to%20repair%20it.%20The%20log%20files%20indicate%20that%20there%20are%20problems%20with%20%22Styles%22%2C%20but%20the%20repaired%20file%20looks%20pretty%20okay.%20Compared%20it%20to%20opening%20the%20file%20on%20a%20PC%20and%20that%20one%20does%20not%20have%20any%20problems.%20The%20slicer%20styles%20come%20out%20dark%20blue%20buttons%20on%20light%20blue%20background%20on%20the%20Mac%20where%20on%20the%20PC%20it's%20dark%20blue%20on%20white.%20Then%2C%20on%20the%20Quote%20sheet%20in%20the%20top%20left%20hand%20corner%2C%20the%20conditional%20format%20that%20whites-out%20some%20cells%20below%20%22Employee%20count%22%20on%20the%20PC%2C%20doesn't%20seem%20to%20work%20the%20same%20as%20the%20formatting%20colours%20changed.%20See%20screenshot%20taken%20on%20the%20Mac.%20Don't%20know%20what%20causes%20this.%20Never%20experience%20it%20before.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-10-20%20at%2009.38.00.png%22%20style%3D%22width%3A%20423px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F318644i656CA3087715217D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-10-20%20at%2009.38.00.png%22%20alt%3D%22Screenshot%202021-10-20%20at%2009.38.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all--I'm at my wits end to this and have no clue what other solutions to try. 

 

Context: Organizational license, everyone has Excel 365. 

Created a new default style for Slicers/tables/pivottables.

Works fine on my own device and other Mac devices. ONLY errors out on international Mac devices. 

 

I have custom formatted PivotTables, slicers, and tables on my workbook model that follow my companies design theme. On file open, the formats appear fine on both my Windows and Mac devices. 

 

However, when my colleagues in EMEA & APAC open the file, they get a file corruption dialogue box and notice to repair Excel file. After repairing, all the styles are completely messed up.

Where the table would have a header in blue fill & bold format, is now instead showing every other row with that format and all white font. I never set that style, however if I investigate the faulty spreadsheet, it will show that as the set style. 

It appears that the custom table/slicer/pivottable style is not being recognized on specifically Mac devices, outside of North America.

 

 

Solutions tried so far:

1. Using Inquire add in to clean excess formatting. Doesn't seem to do anything

2. Using XLStyles tool to investigate file and process. No dice.

3. Removing custom formats all throughout, however can't seem to fully eradicate issue. 

 

Any guidance or solutions would be greatly appreciated--

 

6 Replies

@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.

Screenshot 2021-10-20 at 09.38.00.png

 

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 styles

@Kazi_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?