Custom lists not always working on other users' computer

cr731

Well-known Member
Joined
Sep 17, 2010
Messages
611
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 reason why this would be happening for some users and not others?

All are using Excel 2013.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
This is 2010 documentation but presume its same/similar:

How custom lists are stored

Once you create a custom list, it is added to your computer's registry, so it is available for use in other workbooks. If you use a custom list when sorting data, it is also saved with the workbook, so that it can be used on other computers, including servers where your workbook might be published to Excel Services and you want to rely on the custom list for a sort.
However, if you open the workbook on another computer or server, you do not see the custom list that is stored in the workbook file in the Custom Lists dialog box that is available from Excel Options, only from the Order column of the Sort dialog box. The custom list that is stored in the workbook file is also not immediately available for the Fill command.
If you want, you can add the custom list that is stored in the workbook file to the registry of the other computer or server and make it available from the Custom Lists dialog box in Excel Options. From the Sort dialog box, under the Order column, select Custom Lists to display the Custom Lists dialog box, select the custom list, and then click Add.
 
Upvote 0
My issue is that this is not always happening...

If you use a custom list when sorting data, it is also saved with the workbook, so that it can be used on other computers
 
Upvote 0

Forum statistics

Threads
1,223,936
Messages
6,175,507
Members
452,650
Latest member
Tinfish

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top