x Want to participate? Join the group to interact
New

Allow Sage 50Cloud Accounts to export to Excel

Hi,

Whenever we try to export to Excel from Sage 50Cloud Accounts, we get an error message saying "Failed to connect to Excel."

Although this issue may have been seen before, what is different as far as we can see is that we are using it on Windows 10 on Microsoft's Azure Cloud Desktop. I spoke to Sage and incredibly they will not support this because it is on a cloud desktop!

We have been using Sage Accounts for many years and have never seen this issue before. We still have Sage Accounts on physical PC's which do not see this error at all; it is only on the cloud desktop. The version of Windows 10 that is on the cloud is the same as any other that you would come across.

I have also checked some other standard settings...

- Both Office and Sage have been re-installed.

- Office / Excel is 32-bit.

- HKCR\Excel.Application is in the registry.

- Sage run as Administrator, although never needed to in the past on physical PC's.

Please can someone advise how we can fix this as Sage won't help, or can Sage please fix this for the next release, so that Sage Accounts can export to Excel on the Azure Cloud desktop.

Thank you.

Nicoleta Spiridon
  • in reply to Nicoleta Spiridon

    If they are on the same PC then it would suggest there is something environmental that is stopping us creating the Excel instance. Simple being on a cloud based VM should have no bearing on the issue and my guess is there is something else at play.

    Could you open a command prompt and run the following command:

    reg query HKEY_CLASSES_ROOT\Excel.Application\CLSID

    This should give you an output something like this

    HKEY_CLASSES_ROOT\Excel.Application\CLSID
(Default) REG_SZ {00024500-0000-0000-C000-000000000046}

    NOTE The string of letters and numbers (knows as GUID) may differ on your PC depending on the version of Excel that is installed.

    Once you have the GUID as above if you then run the commands, replacing the GUID with the one from the result in the first command if yours is different to the above example

    reg query HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\InprocServer32

    and

    reg query HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer32

    and share the output from those commands here please?

  • in reply to Darron Cockram

    Yes, Sage and Excel are installed on the same cloud machine / instance.

  • "Failed to connect to Excel." - that error message happens when the Accounts code cannot find, or cannot create an instance of Excel. There are quite a few reasons why this might happen and it certainly sounds like you have already looked at some of them. One thing I was wondering though: is Excel installed on the Windows 10 on Microsoft's Azure Cloud Desktop instance i.e. on the same machine as Accounts is installed, or is Excel on your local PC and you are running Accounts on the Azure VM?

*Community Hub is the new name for Sage City