Excel custom list - not showing up when emailing the file

%3CLINGO-SUB%20id%3D%22lingo-sub-3025309%22%20slang%3D%22en-US%22%3EExcel%20custom%20list%20-%20not%20showing%20up%20when%20emailing%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3025309%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFacing%20a%20problem%20on%20an%20excel%20dashboard%2C%20the%20slicer%20(using%20the%20custom%20list)%20will%20not%20show%20the%20data%20in%20the%20sequence%20added%20in%20the%20custom%20list%20when%20emailing%20the%20file%20to%20other%20colleagues.%20File%20and%20tabs%20are%20password%20protected.%3C%2FP%3E%3CP%3EAny%20suggestions%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3025309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3026189%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20custom%20list%20-%20not%20showing%20up%20when%20emailing%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026189%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1235756%22%20target%3D%22_blank%22%3E%40fmatta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20custom%20list%20which%20is%20defined%20in%20the%20Excel%20options%20is%20available%20only%20on%20the%20computer%20where%20it%20has%20been%20defined.%20It%20is%20not%20included%20in%20the%20workbook.%20Therefore%20your%20colleagues%20do%20not%20have%20the%20custom%20list%20and%20the%20slicer%20gets%20always%20sorted%20alphabetically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20sort%20order%20is%20the%20only%20thing%20that%20you%20can%20define%20in%20the%20slicer%20options%20(sort%20ascending%20or%20descending)%20that%20will%20go%20with%20the%20worbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

Facing a problem on an excel dashboard, the slicer (using the custom list) will not show the data in the sequence added in the custom list when emailing the file to other colleagues. File and tabs are password protected.

Any suggestions? 

2 Replies

Hi @fmatta 

 

a custom list which is defined in the Excel options is available only on the computer where it has been defined. It is not included in the workbook. Therefore your colleagues do not have the custom list and the slicer gets always sorted alphabetically.

 

This sort order is the only thing that you can define in the slicer options (sort ascending or descending) that will go with the worbook.