Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting and Saving (Excel2000)

    After sorting a worksheet I am unable to save. The Task Manager indicates that the worksheet is still running but it's hung up. If the file was corrupt I couldn't open it. But it works fine until I sort.??????
    Paul B

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting and Saving (Excel2000)

    A workbook can be corrupt in different ways - you may still be able to open a corrupt workbook. Do you know someone with Excel 2002 or later? You might ask them to use Open and Repair to open the workbook. If the workbook doesn't contain sensitive information, you can attach it to a reply (zipped if necessary; limit 100 KB).

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting and Saving (Excel2000)

    Hans, Learning VBA is a lot easier than dealing with corrupt files. I just installed Excel 2007. Excel 2000 is still installed. On this particular spreadsheet there two columns both integers. Now all of a sudden they are opening as "TEXT". Why????
    When I use the format cells routine --number no decimals--nothing happens.
    Another mystery is when I try to sort this worksheet. I sort three columns and the last 9 columns to the right dissappear.(no hidden columns)
    Paul B

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting and Saving (Excel2000)

    You could try the following to convert the text values to numbers:
    - Select an empty cell.
    - Press Ctrl+C to copy the cell.
    - Select the columns with text values that should be numbers.
    - Select Edit | Paste Special...
    - Select the Add option.
    - Click OK.

    About the sorting problem: could the non-blank values have been pushed down out of sight somehow?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •