Custom list stored in workbook

[rafael r]

Forum, my question is an extension of a question posted a few years ago but I don't believe we have a solid solution:

Custom lists not always working on other users' computer

I use custom lists for sorting in pivot tables and when I send the file out to other users, some of them see the list sorted properly and others do not. I thought that the custom list was supposed to stay with the file, even if the user doesn't have that list on their computer? Is there any...

www.mrexcel.com

I have the same problem. The custom list I created in a workbook, it is not appearing when a member of my team opens the workbook. Hence, if a member of my team creates a new pivot table, the custom sort cannot be apply. Please advice. Thanks!

 

[rafael r]

possibly important to know that I used power query to reorganize the data and power pivot to create some customize measures. The tried the solution provided by one of the users in the above link but it doesn't work for me.

 

[JEC]

if the custom list is not available after sharing your workbook, you can create the custom list while opening the file for example (with vba)

 

[GraH]

Or load the table in Power Pivot and via PQ you create a sort index for that column. Hide that column in the user view.. define for the columns to sort, they must be sorted using the custom sort key.

Each pivot creatief will adopt the correct sort order.