Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Friday, May 14, 2010

How to install Salesforce.com Connect for Office with MS Office 2010 (Excel only)

Well, it doesn't by default. The installer runs without error, but there'll be no Salesforce.com ribbon available. I don't know what went wrong, but you get nothing in Office14/xlstart directory. If you do the same thing with Office 2007, you'll get a SFDC.xla, and a SFDC12.xlam in the directory. I tried this on two separate Windows 7 instances, one virtual, one physical, both x64, with the same result. Office 2010 is x86. Connect for Office is 1.8.1.1.

Since the juice is all in the xla files, I decided to just copy the 2 files from a working Office 2007 machine to an Office 2010 VM. Files copied, open Excel 2010, and voila! Salesforce.com ribbon works as expected. I could log on, import reports, refresh them, all without issues.

The source machine for the files has Connect for Office 1.8.0.8.

BTW, it looks like Office13 is skipped. Why do people have to be that superstitious?

Update and disclaimer: here's a link I put up for downloading the 2 needed Office files.  These are SFDC Connect for Office files and the intellectual property belongs to no one but Salesforce.com.  The link should be up as long as they do not object to them being distributed this way.