• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom Lists

Portucale

Member
Hi,

I've created a custom list to sort a slicer, however when someone else open the workbook the sort is no longer by the custom list, any ideas how could I resolve the issue and have the custom list available for everyone?

Any help and all the help is appreciated.

Thanks in advance,
 
Have You checked this?

https://support.office.com/en-us/ar...ing-data-D1CF624F-2D2B-44FA-814B-BA213EC2FD61

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.
 
Hi,

I have follow the steps, and still no joy??

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

Any idea? Is there any way that coudl possibly create a Macro with the "Custom Lists"?


Thanks in advance,
 
Are the other users opening the file on their computer? It is a list stored on your machine.
Excel users seem to forget that Excel is not and was never designed for multi users, other software such as Access is designed for that it is far better at doing it.
Excel was never designed to plaster a wall but many ask why it does not.
 
Macro sample...
Code:
Sub Add_Custom_List()
    Application.ScreenUpdating = False
    On Error Resume Next
'   change "Lists" to Your used sheet
'   change "A2:A20") to Your used range
    Application.AddCustomList ListArray:=Sheets("Lists").Range("A2:A20")
    Application.ScreenUpdating = True
End Sub
 
Back
Top