Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    Sometimes when I save a worksheet, the Excel 2007 compatibility checker reports a "minor loss of fidelity". Sometimes it provides a "Find" option but sometimes not (why?). How can I locate the incompatibilities when there is no "Find" option?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I think it is a case of Excel thinking it is smart enought to know whether certain types of things done in 2007 won't properly display in 2003 and earlier. I have seen the same behavior as I work back and forth in both formats. I think the ones that don't display the Find option are things like special color shading, and subtle variations in borders display.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    Thanks for your reply. I would like to know if it is possible to locate the incompatibilities.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately, to my knowledge there isn't any tool that will give you that if it doesn't indicate what they are when you save it. But perhaps someone else can shed more light on the subject.

    Edit - I should have pointed out that you can run the compatibility checker on the workbook at any time. Click the Office button, chose Perpare and then Run Compatibility Checker. Also if you search Excel Help for incompatibilities one of the references talks about common issues you may encounter.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post
    I'm attempting to automate the creation of spreadsheets (97-2003 .xls) using a custom 97-2003 template from Access 2007. All works well (the spreadsheets are saved) however the Compatibility Checker is always poping up. Is there a way to turn this off or have it ignored? Following is the base code I'm using which is contained within a recordset processing loop . Multiple spreadsheets may be created, so having the Compatibility dialog displayed with each save is a major pain.


    Set xlApp = GetObject(, "Excel.Application")If _

    Err.Number <> 0 _

    Then 'Flag the fact and Start Excel

    fExcelWasNotRunning = True

    Set xlApp = CreateObject("Excel.Application")

    Err.Clear

    End If



    Set wkb = xlApp.Workbooks.Open(FileName:=stXLSTmplt)

    Set sht = xlApp.ActiveWorkbook.Sheets(1)

    wkb.SaveAs _

    FileName:=stExpndPath & rstDAOLog!wkLogWName & ".xls", _

    FileFormat:=xlExcel8 '97-2003 format

    Thanks for the help,
    Marty


  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    there is a switch to set before saving in excel
    ActiveWorkbook.CheckCompatibility = False
    turns off the compatibility checker.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  7. #7
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post
    Catherine,

    Thanks much.

Posting Permissions

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