Friday, May 14, 2010

TF237002: Cannot open the document because Microsoft Excel 2007 or later, or one of its components is not installed.

One of my colleagues got the following error each time he tried to export workitems to Excel from within the Team Explorer 2010 client:

TF237002: Cannot open the document because Microsoft Excel 2007 or later, or one of its components is not installed.

It took me some time to figure out what was wrong:

During the installation of Office 2007 he disabled the Office .Net Programmability Support.

To enable it you need to modify your installed version of Office and install this option.

1. In Add/Remove programs, locate your Office application and select it.
2. Click on the 'Change' button
3. Select 'Add or Remove features' and click 'next'
4. Select 'Choose advanced customization of applications' and click 'next' OR select something like 'Add .Net programmability support'.
5. In the tree view, expand 'Microsoft Office Excel' and make sure the .NET Programmability Support option is set to 'run from my computer'.
6. Click 'update'.

8 comments:

Alex said...

I often use with excel files. But I opened my MS Excel program every day for work. But yesterday something happened with my tool and I didn't find my emails inside. Luckily for me my friend advised me - excel cannot open file. It determined my problem quite simply and free of cost as I bore in mind.

Nicola Celiento said...

Thanks!

Nedzer said...

thanks for the clear instructions on how to fix this

Anonymous said...

Thanks it was really helpfull to me with my VS2010/TFS2010/office2007

Somair said...

Thanks a lot, solved my long due problem

Anonymous said...

Thanks a lot, myself and my team were having this issue since long.
Thanks a lot...

:-)

GKK

Anand said...

Thanks, it fixed my issue

Anonymous said...

Thank you! fyi I got to this page from http://social.msdn.microsoft.com/Forums/vstudio/en-US/f60b7559-356e-4d9e-a33b-026c9b07f59a/error-messages-tf237002-tf80070-and-tf86002-when-open-querydocument-from-tfs-in-excel-or-project?forum=tfsworkitemtracking