Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
I receive a monthly spreadsheet from another department that I re-sort by
product numbers using a custom sort list. Recently one of the product numbers was not being recognized so it would be pushed to the end of the list every time. It also was not recognized when running a macro. I found that by "clearing" the cell and re-typing the product number fresh, it will get picked up and appear at the correct place on the list after sorting. (NOT deleting, or cut/pasting or copy/pasting or paste-special value only - none of which work) Any idea what causes this? Using Excel 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt data question.. | Excel Discussion (Misc queries) | |||
Corrupt .xltm | Excel Discussion (Misc queries) | |||
Corrupt screen on startup | Excel Discussion (Misc queries) | |||
The document is corrupt | Excel Discussion (Misc queries) | |||
Corrupt Spreadsheet | Excel Discussion (Misc queries) |