NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm

Merge Formula Issues With Server Side Merging

Owned by Tony Hayes
Last updated: Jul 02, 2019
1 min read

Application Scope: CORE

Problem

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.

Solution

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.


Article Images:


NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm