Excel found unreadable content in .xlsm

[gsot21]

I have a sheet that works perfectly fine. When I edit the links to new work sheets and save it as a new file name, everything works fine. Then when I reopen the sheet, I get warning that excel has found unreadable content in the document. When I click yes, it repairs sheets, but removes all of my links. Here are the repairs:


<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error097920_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\uc186508\Desktop\Pipeline & Forecast 3_3_15.xlsm'</summary>-<repairedParts summary="Following is a list of repairs:"><repairedPart>Repaired Part: /xl/worksheets/sheet14.xml part with XML error. Load error. Line 2, column 94942.</repairedPart></repairedParts>-<removedFeatures summary="Following is a list of removed features:"><removedFeature>Removed Feature: External formula reference from /xl/workbook.xml part (Workbook)</removedFeature><removedFeature>Removed Feature: External formula reference from /xl/styles.xml part (Styles)</removedFeature></removedFeatures>-<removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Formula from /xl/worksheets/sheet6.xml part</removedRecord><removedRecord>Removed Records: Formula from /xl/worksheets/sheet9.xml part</removedRecord><removedRecord>Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)</removedRecord></removedRecords></recoveryLog>

Any ideas what I can do to original sheet to stop this from happening? Thanks.