Sage 50 v27 - Excel Ingregation - Refresh no longer working

SUGGESTED

Hi.

I've recently upgraded from v26 to v27 and reinstalled EIR as instructed.

If I generate a new report in Excel, it works fine, so I think the data links are ok.

However, if I click on 'Refresh' to get updated data, after a few seconds thinking time, I get an 'Error Executing Report' error box with the unhelpful message 'One or more errors occurred.'

I can't get a single report to refresh.

Any suggestions?

Many thanks, Ian

Parents
  • 0

    I've tried editing the registry, but now wont let me add the company back.

    If I try to Add company, I get a 'Connection Error' error box with a long message starting 'Unable to connect to the Sage Data Service on machine 127.0.0.1 ...' and then gives several reasons why that might be. Without knowing what machine is meant by 127.0.0.1, it's hard to track further.

    Many thanks,

    Ian

  • 0 in reply to Ian Burgess

    127.0.0.1 is the local machine (known as localhost). That error means that Excel is trying to connect to the Accounts dataservice on the that machine but if cannot. The error message should provide some troubleshooting notes but I'd suspect that the most likely cause of this is that the service is not running. One thing to note is that it Excel will try to connect to the dataservice for each version of the data it finds i.e. if you have v26 data it will try to connect to the v26 data service, if it also finds v27 data it will try to connect to the v27 data service, etc. The error message could relate to any version so make sure the data service is running for all versions.

Reply
  • 0 in reply to Ian Burgess

    127.0.0.1 is the local machine (known as localhost). That error means that Excel is trying to connect to the Accounts dataservice on the that machine but if cannot. The error message should provide some troubleshooting notes but I'd suspect that the most likely cause of this is that the service is not running. One thing to note is that it Excel will try to connect to the dataservice for each version of the data it finds i.e. if you have v26 data it will try to connect to the v26 data service, if it also finds v27 data it will try to connect to the v27 data service, etc. The error message could relate to any version so make sure the data service is running for all versions.

Children
No Data