This Excel Add-in provides bi-directional access to the Force.com API via the Toolkit for Office, and is useful for cleaning and mass-updating salesforce.com-based data from within a spreadsheet. Updated features include access to Products2 and custom objects, API names or labels, simple query wizard, readable user names, and more.
The new version is found here : http://code.google.com/p/excel-connector/
Subject: Fix for Excel Connector problem
Hi All, A couple of weeks ago, an email was sent around reporting that the connector did not work. Error was something like this:
“Microsoft Visual Basic: System Error &H80004005 (-214746259) Unspecified Error”
Well there is a fix.
Try this, to any and all that are affected (because it worked for me).
Run Office Diagnostics and it will fix the issue. The self-diagnostic process normally takes 7-10 minutes:
Goto Start>All Programs>Microsoft Office>Microsoft Office Tools>Microsoft Office Diagnostics and let it run a full scan.
Hope this helps others with similar issues, and many thanks to the IT team who identified this fix!