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.
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.