T
TrishaB
I have been given an Excel 2000 worksheet to
troubleshoot. It was created for one of our departments
by an outside vendor.
When they try to sort the worksheet using the first column
as the sort criteria, it sorts the first 69 records
correctly, then begins a new sort on the 70th record
(e.g., correctly sorts values 1014-1489, then restarts at
1000-6000).
I have: Removed the header row, copied the column into a
new worksheet, searched for macros/VBA code (found none),
searched for formulas (again found nothing), conditional
formatting (ditto), importing into Access 2000 (get a Type
Conversion Failure for some of the values in that first
column), and exporting into Notepad (no special characters
show up), and finally, exporting into Word 2000 where I
was finally able to convert the text to a table and
successfully sort it there, but was then unable to
successfully get it back into Excel.
Another interesting behavior: it's impossible to apply
different formatting to the data in the second part of
this column. I've been able to create and apply a custom
format for the first records, (five character number
rather than four, and get a leading zero on all numbers
until I hit the fateful row), but can change font
formatting (bold, italics, etc.), but there's no special
protection set on the worksheet, workbook, or cells.
I've highlighted the whole thing and erased formulas
(there don't appear to have been any), and saved it as a
different document name.
I'm out of ideas.
If anyone has seen this type of behavior before and has
any information on how to address this, I'd appreciate the
benefit of your knowledge.
Many thanks in advance,
Trisha
troubleshoot. It was created for one of our departments
by an outside vendor.
When they try to sort the worksheet using the first column
as the sort criteria, it sorts the first 69 records
correctly, then begins a new sort on the 70th record
(e.g., correctly sorts values 1014-1489, then restarts at
1000-6000).
I have: Removed the header row, copied the column into a
new worksheet, searched for macros/VBA code (found none),
searched for formulas (again found nothing), conditional
formatting (ditto), importing into Access 2000 (get a Type
Conversion Failure for some of the values in that first
column), and exporting into Notepad (no special characters
show up), and finally, exporting into Word 2000 where I
was finally able to convert the text to a table and
successfully sort it there, but was then unable to
successfully get it back into Excel.
Another interesting behavior: it's impossible to apply
different formatting to the data in the second part of
this column. I've been able to create and apply a custom
format for the first records, (five character number
rather than four, and get a leading zero on all numbers
until I hit the fateful row), but can change font
formatting (bold, italics, etc.), but there's no special
protection set on the worksheet, workbook, or cells.
I've highlighted the whole thing and erased formulas
(there don't appear to have been any), and saved it as a
different document name.
I'm out of ideas.
If anyone has seen this type of behavior before and has
any information on how to address this, I'd appreciate the
benefit of your knowledge.
Many thanks in advance,
Trisha