Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort corrupts mass data intermittently?
Im in a fix. I have to do a csv export of our database table which equates to 9000 rows by abou 40 columns. Some of these columns host full html data. The problem is that while managing this data while integrating a large amount of rows into the csv we sometimes have to sort by column. We have done this both by using the A/Z sort button short cut, and by clicking the upper left box where all cells get highlighted, clicking Data, then Sort, and choosing appropriate columns to sort by. Sometimes we hide columns in order to manage 40 columns of data. However from time to time in a manner we can not yet duplicate or determine (though we have a suspision that it is hidden data) we find that data that was was not sorted even though we choose to have all fields sorted becomes disassociated with it's respective row and the data ends up being corrupted. Though this is not to say that we are sure that hidding data is even relevent. Has anyone seen this behavior? Is there a fix, or switch, or different tool we should be using to do mass sorting, and resorting without fear of loosing data integrity?:( -- robreil ------------------------------------------------------------------------ robreil's Profile: http://www.excelforum.com/member.php...o&userid=35467 View this thread: http://www.excelforum.com/showthread...hreadid=552443 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort corrupts mass data intermittently?
Just bumping this thread. Sitting here refreshing looking for answers. -- robreil ------------------------------------------------------------------------ robreil's Profile: http://www.excelforum.com/member.php...o&userid=35467 View this thread: http://www.excelforum.com/showthread...hreadid=552443 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |