Forum Discussion

ITHRBruce's avatar
ITHRBruce
Copper Contributor
May 16, 2022

Sage Accounts showing failed to connect error message when exporting to Excel

We have Azure Virtual Desktops that are shared by a number of users. 32-bit MS Office was installed as usual normal via the Office Deployment Tool. We also have Sage Accounts installed, mirroring a s...
ITHRBruce's avatar
ITHRBruce
Copper Contributor

lctimcoles

 

Hi,

 

Yes, I discovered that if I run a Quick Repair (via Control Panel, Programs and Features, MS Office 365, Change) on the PC in question, then it works without any problem. So try that. I sometimes had to also do it after a restart for a Windows Update, which may have caused it in the first place. So if it fails again, do a Quick Repair.

 

Apologies for not posting this before now, I thought I had done so.

 

Good luck.

Chris House's avatar
Chris House
Copper Contributor
Jun 19, 2023

ITHRBruce lctimcoles 

Having the same problem with one of our remote desktop session hosts.

When you install Office using the deployment tool it doesn't show up in Control Panel - Programs but I have tried reinstalling using the deployment tool. Still get the same problem.

 

It's only affecting one out of our three RDS session hosts but still frustrating.

  • ITHRBruce's avatar
    ITHRBruce
    Copper Contributor
    Jun 26, 2023
    Hi,
    Doing a quick repair sorted it for us. Try that.
    Bruce
    • Chris House's avatar
      Chris House
      Copper Contributor
      Aug 14, 2023
      Still the same problem unfortunately after doing the quick repair 😞
      • ITHRBruce's avatar
        ITHRBruce
        Copper Contributor
        Aug 14, 2023

        Hi Chris House we are pushing our users towards using ODBC to pull data into Excel from Sage, instead of pushing it from within Sage. See if that works for you. Good luck.

         

         

         

Resources