I have a Windows 8 machine with VS 2010, VS 2012 and Office 2013 64-bit installed.
We have a large VS 2010, Excel 2010 add-in template project that we are able to run and debug fine on a machine with Office 2010/2013 32-bit. However on this machine with Office 2013 64-bit, we get a COMException saying:
Retrieving the COM class factory for component with CLSID {62F8CCF6-3C71-11D2-8B38-00A0C970A730} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
I ensured the project is built for 64-bit architecture.
We had installed Office 2010 PIA (http://www.microsoft.com/en-in/download/details.aspx?id=3508) on this machine after which we are able to build and run the Excel add-in project but it generates the COMException at run-time.
We created another Excel 2013 template add-in project using VS 2012 and we are able to build, deploy and debug it just fine in Offce 2013 64-bit.
So on this setup, what can be done to make the Offce 2010 template project debuggable in VS 2010/2012.