Dec 01 2021 04:27 PM
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?
Dec 01 2021 11:59 PM
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.
Dec 02 2021 03:22 AM