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.

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

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<LOGFILENAME>error069600_01.xml</LOGFILENAME>
<SUMMARY>Errors were detected in file 'C:\myfiles\MYNEWFILE.xlsx'</SUMMARY>
- <ADDITIONALINFO>
<INFO>Invalid hyperlinks were found and have been removed.</INFO>
<INFO>Invalid hyperlinks were found and have been removed.</INFO>
</ADDITIONALINFO>
</RECOVERYLOG>

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.
</RECOVERYLOG>

What happens if you manually correct or remove the hyperlinks, then save the file?

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.

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

exceltm said:

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

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<LOGFILENAME>error069600_01.xml</LOGFILENAME>
<SUMMARY>Errors were detected in file 'C:\myfiles\MYNEWFILE.xlsx'</SUMMARY>
- <ADDITIONALINFO>
<INFO>Invalid hyperlinks were found and have been removed.</INFO>
<INFO>Invalid hyperlinks were found and have been removed.</INFO>
</ADDITIONALINFO>
</RECOVERYLOG>

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.
</RECOVERYLOG>

Click to expand...

Well, one problem may be that you saved the file with an .xlxs extension instead of an .xlsx extension (according to the quoted post).