I get the following error when I try to open Excel documents stored on the TFS.

TF84037: There was a problem initializing the Microsoft Excel Team Foundation Addin. Re-installing the Team Foundation Client may be required.

I've attempted a full uninstall and re-install but that have no effect.

This is in the RTM release.

This error happens for every Excel file opened from the project (I only have one project). I can also cause this by opening Excel and clicking New List on the TFS toolbar in Excel.

One other note on the issue, this error always fires twice.

I had tried that but did it again just in case, it had no effect.

Marc,

I'm going to need a log file to have any hope of figuring out what is going on. Please create a new file in the location where Excel.exe exists called Excel.exe.config and place the following XML in that file:

<configuration>
<system.diagnostics>
<switches>
<add name="General" value="3" />
</switches>
<trace autoflush="false" indentsize="3" />
</system.diagnostics>
</configuration>

This will cause a log file to be generated in your %temp% directory called tfs_msexcel.log. Run Excel, cause the problem to occur, then post the contents of the generated log file (there should be an exception entry in it).

-Dennis

[Info, PID 688, TID 3136, 20:10:27.875] Managed ELead Excel AddIn loaded
[Error, PID 688, TID 3136, 20:10:27.968] {

[Error, PID 688, TID 3136, 20:10:28.015] Exception: {
Exception Message: Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. (type FileNotFoundException)

Exception Stack Trace: at Microsoft.TeamFoundation.OfficeIntegration.Client.ExcelAddIn.OnConnectionInternal(Object application, ext_ConnectMode connectMode, Object addInInst)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ExcelAddIn.OnConnectionProxy(Object application, Int16 connectMode, Object addInInst)

}
[Error, PID 688, TID 3136, 20:10:28.015] }

I did a search for the file 'Microsoft.Office.Interop.Excel'. This may not mean anything, but the only version under Program Files was in the Microsoft Small Business Accounting folder. Could there be a conflict between the two applications?

It looks like Office 2003 .Net programmability support is not installed. You need to modify your installed version of Office and install this option. I thought we had a better error message for this...

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'

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

Hello,

I have a similiar problem. if I install the .net support from Office Professional 2003, the connect to the team server via Projects 2003 does'nt work but with Excel, and if I install the Projects 2003 .net support, the connect via MS Excel doesn't work but I can connect with Excel to TFS.

Is there a way to use Excel and Project on the same machine to connect to a team Server ?

Thanks

Alex

They both should work on the same machine. Generally Project is installed separately from Office 2003 (will show up separately in Add/Remove programs). Make sure you configure Project to support .Net programmability as well as Excel.

If this still doesn't work, please create a winproj.exe.config file with the contents specified earlier in this thread and place that file in the same directory as winproj.exe. That will generate a file call tfs_msproject.log in your %temp% directory (if the managed addin is getting loaded at all, that is). Please try it again and post the contents of that file.

Hi,

I am facing a similar problem with my TFS. While trying to open the excel documents I get the following error.

"TF84037: There was a problem initializing the Microsoft Excel Team Foundation Addin. Re-installing the Team Foundation Client may be required."

I tried reinstalling TF client but it was of no use.

I tried generating the log file as mentioned earlier in the thread but there was no log file generated in the temp directory.

There is no error when I open the MSProject files however they are all blank.

Thanks,

Sitaram

I get a slightly diferent problem:

This error occurs after the status bar finishes its "importing tfs data.." message:

[Info, PID 5020, TID 4948, 13:21:52.461] Managed ELead Excel AddIn loaded
[Error, PID 5020, TID 4948, 13:22:06.695] {

[Error, PID 5020, TID 4948, 13:22:07.586] Exception: {
Exception Message: Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND)) (type COMException)

Exception Stack Trace: at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.ListObjects.Add(XlListObjectSourceType SourceType, Object Source, Object LinkSource, XlYesNoGuess XlListObjectHasHeaders, Object Destination)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ListObjects.Add(Range source)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadListObject..ctor(ExcelAddIn addin, Range range, ELeadListOptions listOptions)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadWorkbook.InsertListObject(Range range, ELeadListOptions listOptionsIn)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadWorkbook.CreateListInternal(Range range, ELeadListOptions listOptions, ICollection workItems)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadWorkbook.CreateList(ProjectContext projectContext, Range range, String queryReference, Boolean bindToQuery)
at Microsoft.TeamFoundation.OfficeIntegration.Client.ExcelAddIn.InsertListObject()
at Microsoft.TeamFoundation.OfficeIntegration.Client.ExcelAddIn.OnFirstContact(Boolean& Cancel)

}
[Error, PID 5020, TID 4948, 13:22:07.601] }

Any Ideas?

Which version of Office are you using? You need Office2003 to use TFS Excel Add-in

Swamy