Sorry you're having problems with this. We have investigated the issue and a fix for it will be included in the upcoming v27.1 release (current ETA for this is mid December).

In the meantime there is a workaround but it is not pretty and involves editing the Widows Registry - usual warnings about taking care when editing the registry applies if you wanted to do this. If you close Excel, then in the Registry go to HKEY_CURRENT_USER\Software\Sage\Line 50\History\RecentlyUsedCompanies and delete the entry for the company you want to refresh. Then reopen Excel and your spreadsheet with the data you want to refresh, add the company back in via the Sage 50 Accounts tab. The refresh button should now work and any data ranges in the spreadsheet will be refreshed. Unfortunately you will then either have to keep Excel open afterwards or you'll need to perform these steps again.

Alternatively the legacy version of Excel Integrated Reporting is available for download if you log on to your My Sage account and go to the downloads section look for 'v26 - Excel Integrated Reporting (EIR) module' under the updates section. Despite the name this should work with the v27 release but means you will have multiple tabs in Excel and there are no plans to further update or maintain this version so if you are able to wait for the fix with v27.1 that would be the better long term solution.

Sorry you're having problems with this. We have investigated the issue and a fix for it will be included in the upcoming v27.1 release (current ETA for this is mid December).

In the meantime there is a workaround but it is not pretty and involves editing the Widows Registry - usual warnings about taking care when editing the registry applies if you wanted to do this. If you close Excel, then in the Registry go to HKEY_CURRENT_USER\Software\Sage\Line 50\History\RecentlyUsedCompanies and delete the entry for the company you want to refresh. Then reopen Excel and your spreadsheet with the data you want to refresh, add the company back in via the Sage 50 Accounts tab. The refresh button should now work and any data ranges in the spreadsheet will be refreshed. Unfortunately you will then either have to keep Excel open afterwards or you'll need to perform these steps again.

Alternatively the legacy version of Excel Integrated Reporting is available for download if you log on to your My Sage account and go to the downloads section look for 'v26 - Excel Integrated Reporting (EIR) module' under the updates section. Despite the name this should work with the v27 release but means you will have multiple tabs in Excel and there are no plans to further update or maintain this version so if you are able to wait for the fix with v27.1 that would be the better long term solution.