I have a spread sheet with about 15000 records in the sheet. I added a new column and added the numbers for each row.
When I do the sort, the field with the numbers do not move (i.e. record 200 still shows up as number 1).
I tried doing the sort from the home tab and clicking on Sort and filter, but the record number does not change.
If I click on the Data tab and click on sort, again the number does not move.
I tried cutting out about 100 records and trying it and it works correctly.
Bookmarks