...
You have switched to using Server Side merges, or are using ClientSpace NEXT and when you open an Excel merge you receive an error such as "Excel completed file level validation and repair. Some parts of this workbook may have been replaced or discarded. Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"
Cause
Repeating row data above a formula in the workbook has caused the cell references in a formula to become broken.
...
Update the template document to move all of your calculations above the repeating row data on the worksheet. If you need this data presented below the repeating row information, hide the fields at the top of the workbook and point to these fields using cell references below the repeating row data.
Related articles
...
Article Images:
...