Results 1 to 7 of 7

How to fix/eliminate MINOR LOSS OF FIDELITY errors?

This is a discussion on How to fix/eliminate MINOR LOSS OF FIDELITY errors? within the Excel Questions forums, part of the Question Forums category; I get an error when trying to save, "Minor loss of fidelity" in Excel 2007 spreadsheet. How do I eliminate ...

  1. #1
    New Member
    Join Date
    Apr 2010
    Posts
    30

    Default How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    I get an error when trying to save, "Minor loss of fidelity" in Excel 2007 spreadsheet. How do I eliminate this warning everytime I save the file? I recently upgraded from 2003 to 2007 and now get this error. Some files have 18 "number of occurrences" under this warning.

    "Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available."

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    26,996

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    I think it is because you are using Excel 2007, and saving the files with an ".xls" extension, which is Excel 2003 and before. So some of the options you see in 2007 and not available in 2003 and before.

    If you save the file with a ".xlsx" extension, I believe you will not get that message.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Apr 2010
    Posts
    30

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    Now getting this, in an endless loop...

    Errors were detected while saving MYFILE.XLXS. MS Office Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.

    Then I save as a new file name and get

    Errors were detected in MYNEWFILE.XLXS, but MS Office Exceo was able to save the file by removing or reparing the features listed below.
    Invalid hyperlinks were found and have been removed.
    Invalid hyperlinks were found and have been removed.
    Click to view log file listing repairs: C:/users/etc/error069600 01.xml


    - http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    error069600_01.xml
    Errors were detected in file 'C:\myfiles\MYNEWFILE.xlsx'
    -
    Invalid hyperlinks were found and have been removed.
    Invalid hyperlinks were found and have been removed.



    If the invalid hyperlinks WERE REMOVED, why do I continually get this error every time I save the file? I search MrExcel and help inside Excel and could find no solution.

  4. #4
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    26,996

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    What happens if you manually correct or remove the hyperlinks, then save the file?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    New Member
    Join Date
    Jan 2011
    Posts
    1

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    The "loss of fidelity" is likely the result of different color definitions used between the two versions. If you want to save the workbook in the older format, you need to use only colors that are defined in the older versions of Excel. To see these, click on the Office button, pick Excel Options from the bottom of the frame, and go to the Save tab. Click on the Colors... button, and you'll see the palate available for the older versions. You can see the RGB values for colors in the palate by choosing one, clicking the Modify... button, and then going to the Custom tab. To avoid the annoying "loss of fidelity" message, you have to use colors with exactly the same RGB values for the colors in that palate. Check fonts, fills, and lines on all sheets in the workbook.
    Last edited by JohnEfromNJ; Jan 13th, 2011 at 05:03 PM.

  6. #6
    New Member
    Join Date
    Jun 2008
    Location
    Germantown, WI
    Posts
    3

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    JohnEfromNJ,

    How do I find which cells are not in conformity with Excel 2007? I have the same error message and I am trying to determine which cells within the workbook I need to address.

    Thanks

    JPHuff

  7. #7
    New Member
    Join Date
    Aug 2011
    Posts
    1

    Default Re: How to fix/eliminate MINOR LOSS OF FIDELITY errors?

    Quote Originally Posted by exceltm View Post
    Now getting this, in an endless loop...

    Errors were detected while saving MYFILE.XLXS. MS Office Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.

    Then I save as a new file name and get

    Errors were detected in MYNEWFILE.XLXS, but MS Office Exceo was able to save the file by removing or reparing the features listed below.
    Invalid hyperlinks were found and have been removed.
    Invalid hyperlinks were found and have been removed.
    Click to view log file listing repairs: C:/users/etc/error069600 01.xml


    - http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    error069600_01.xml
    Errors were detected in file 'C:\myfiles\MYNEWFILE.xlsx'
    -
    Invalid hyperlinks were found and have been removed.
    Invalid hyperlinks were found and have been removed.



    If the invalid hyperlinks WERE REMOVED, why do I continually get this error every time I save the file? I search MrExcel and help inside Excel and could find no solution.
    Well, one problem may be that you saved the file with an .xlxs extension instead of an .xlsx extension (according to the quoted post).

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com