Sage 200 UKI Ideas Portal

When exporting from Sage 200 to excel, unable to link formulas between 2 excel workbooks

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.

  • Guest
  • Oct 6 2020
  • Delivered
Fixed in version 2024 R1
Implemented in version (specific) 2024 R1
  • Admin
    Jo Kirkup commented
    26 Feb 09:27am

    Changes to how data is exported from Sage 200 has been delivered in the web screens for Sage 200 2024 R1.

  • Admin
    Jo Kirkup commented
    17 Nov, 2023 11:04am

    This behaviour is seen in Excel when using temporary files not created as a throughput from Sage 200. To solve for this you will need to save the files and then your formulas and calculations should apply.

    We are making changes to how excel files are exported, with our 2024 R1 all exports are saved either to Sage temp or a user defined folder and as a result cross workbook calculations can be completed.