Sage failed to connect to Excel

Posted on 2012-09-12
Last Modified: 2012-09-17
I have recently installed Microsoft Office 2010 on a new machine, and subsequently installed Sage Accounts 50 2012. I am unable to export from Sage to Excel, and get the message "Failed to connect to Excel". I have noted the previous answer to a similar query, but I don't think in my case reinstalling Sage would help, as it was installed after Excel.

I can see the addin in Excel, and I can get a logon prompt to Sage from within Excel. If I log on, I then can't run Sage itself as it says the logon is already in use.

Can anyone point me in the right direction?

Question by:pgmiller
    LVL 10

    Expert Comment

    by:Bruce Denney
    What version of Microsoft Office 2010?

    The 64 bit version is incompatible, the 32 bit is fine.

    Author Comment

    It was 64-bit - but we were told by Sage support it should be compatible. If we are going to have to install 32-bit, I would like to be certain that's the problem - have you come across this before, and it definitely is incompatible?
    LVL 10

    Accepted Solution

    Definitely incompatible with 64 bit.

    I have seen some incorrect misinformation floating around Sage say it is compatible, but real life has made it very clear that it is not.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now