If you use Custom Lists to sort data in a workbook, what happens if you send the workbook to others, and they try to sort in that same order?

If you use Custom Lists to sort data in a workbook and then send the workbook to others, they will be able to sort in the same order only if they have the same Custom Lists on their Excel.

Here are the steps:

1. You create a Custom List in Excel to sort data in a specific order that is not alphabetical or numerical.

2. You use this Custom List to sort data in your workbook.

3. You send this workbook to others.

4. When they receive the workbook, they can see the data sorted in the order you specified.

5. However, if they want to sort the data in the same order themselves, they would need to have the same Custom List on their Excel. If they don't, Excel will not recognize the order and will not be able to sort the data in the same way.

6. If they have the same Custom List, they can sort the data in the same order. If they don't, they would need to create the same Custom List on their Excel to be able to sort the data in the same order.