How to fix/eliminate MINOR LOSS OF FIDELITY errors?

exceltm

New Member
Joined
Apr 5, 2010
Messages
32
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."
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,460
Office Version
  1. 365
Platform
  1. Windows
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.
 

exceltm

New Member
Joined
Apr 5, 2010
Messages
32
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>
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,460
Office Version
  1. 365
Platform
  1. Windows
What happens if you manually correct or remove the hyperlinks, then save the file?
 

JohnEfromNJ

New Member
Joined
Jan 13, 2011
Messages
1

ADVERTISEMENT

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:

JPHuff

New Member
Joined
Jun 11, 2008
Messages
3
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
 

zachoxley

New Member
Joined
Aug 26, 2011
Messages
1
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>

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

Watch MrExcel Video

Forum statistics

Threads
1,109,073
Messages
5,526,657
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top