Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CONVERTING FILES (2000 PROF)

    WE HAVE BEEN CONVERTING FILES FROM QUATTRO PRO VERSION 8 TO EXCEL(MICROSOFT OFFICE 2000 PROFESSIONAL) & NOW WE HAVE RUN ACROSS A PROBLEM WITH ONCE THE FILE IS CONVERTED TO EXCEL WE CAN'T FORMAT CELLS. DOES ANYONE KNOW WHAT TO DO WHEN CONVERTING TO AVOID THIS PROBLEM?
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: CONVERTING FILES (2000 PROF)

    I don't know what is going on here; I do know that the used range on the sheet will not permit formatting, and the reason seems to be some non-standard conversion results with the borders of each cell.

    The easiest manual way to fix this is select cell A1, then holding down Shift, press End-Home. This selects the entire used range of the worksheet. Then click the cell border button, click on clear (no borders) from the drop down options, and you are done. If you need to you can restore the borders using the same border button, and you'll still be able to format the cells now that Excel has set borders.

    The following macro does the same thing as the manual steps above.

    Sub ClearQBorders()
    Application.ScreenUpdating = False
    With ActiveSheet.UsedRange
    .Borders(xlDiagonalDown).LineStyle = xlNone
    .Borders(xlDiagonalUp).LineStyle = xlNone
    .Borders(xlEdgeLeft).LineStyle = xlNone
    .Borders(xlEdgeTop).LineStyle = xlNone
    .Borders(xlEdgeBottom).LineStyle = xlNone
    .Borders(xlEdgeRight).LineStyle = xlNone
    .Borders(xlInsideVertical).LineStyle = xlNone
    .Borders(xlInsideHorizontal).LineStyle = xlNone
    End With
    Application.ScreenUpdating = True
    End Sub

    Can anyone else get to the exact problem?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CONVERTING FILES (2000 PROF)

    I don't know why this occurs, but it is some kind of corruption in the workbook that happens in the conversion. There was another thread about this same problem a while back, but I can't find it to point you there.

    I can tell you how to get around the problem. Open the file and do a use SaveAs on the File menu to save the file in HTML format. Close Excel and then start it back up and open the HTML version of the file. Again, use SaveAs to save the file as an Excel Workbook. You should now be able to format the cells.
    Legare Coleman

Posting Permissions

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