List feature (2003)

I have a user who created a spreadsheet and used the Data/List/Create List feature. Since she has done this, it will not sort correctly. It will only sort by last name not last name and then first name.

I am at a lost. I have tried converting to a range and still nothing. The unlink list is not available.
Please help!

Re: List feature (2003)

I apologize for the lack of replies. Apparently nobody has a clue. Perhaps you could post a small sample workbook that demonstrates the problem, so that Loungers can investigate it. Replace sensitive data with dummy data.

Re: List feature (2003)

By the way, I cannot reproduce the problem. When I create a list using Data | List | Create List, I can sort it any way I want using Data | Sort..., using the Sort Ascending and Sort Descending toolbar buttons and the corresponding items in the dropdown menus in the column headers.

Re: List feature (2003)

I appreciate the continued search for my answer. Attached is the spreadsheet. I can sort either by last or first but not by both. Pay attention to the list of Adams. If you use the filter, it will only allow you to sort one column not a multiple column sort.

Re: List feature (2003)

You can run this short macro to remove leading and trailing spaces from all cells with text:

Sub TrimThoseSpaces()
Dim oCell As Range
For Each oCell In ActiveSheet.UsedRange
If Not oCell.HasFormula And Application.WorksheetFunction.IsText(oCell) Then
oCell = Trim(oCell)
End If
Next oCell
End Sub

Re: List feature (2003)

Thanks...you do not know how many countless and unproductive hours I have spent on this spreadsheet. As an IT helpdesk manager, you think that I would not assume that the user keyed in the data correctly.

I will use the macro and actually have it run when the spreadsheet is opened.

One more question, I have another spreadsheet that is shared between users. When one user is entering in numbers, Excel will automatically add a row above the total. If you add another number, another row is inserted. Under Tools/Shared workbook, the option is checked to allow changes...if I remove the check, it does not insert the additional rows. Is this the reason it is adding rows? I tried to remove some data so I could attach, but it will not allow me to delete the other spreadsheets in the workbook and if I copy the one, it does not do it.

Re: List feature (2003)

I strongly recommend *not* to use the Share Workbook feature. Excel is not good at this, and it can easily cause your workbook to become corrupt.
If the workbook is not shared, only one user can edit it at a time; other users get a warning with an option to be notified when the workbook is available for editing again.
If you really need multi-user capability, think about using Access.