When exporting from Sage 200 to excel, unable to link formulas between 2 excel workbooks. Using formulas which should link between 2 excel documents, the 2nd book excel document is not being picked up and pulled into the formula in the 1st workbook. This has been tested on several platforms, including on customers site an off site on 2 environments.
The workaround is to save the books first, then the formulas will link and calculate.
When not using the export from Sage to excel, and using 2 new work books created directly from Excel, the formulas will link without having to save the excel documents.
Call Case reference logged with Sage = 01195921, there is no known issue logged. It was suggested to add this to the ideas hub.