'Team' tab in Excel not functioning.

Question

Here is the content of the error that I got when trying to export data from Azure DevOps to Excel via the 'Team' tab.

Excel is running into problems with the 'tfcofficeshim.connect.16' add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?

Yes No

I have disabled and enabled the Team tab back per directions and tried to export data from Azure Devops into Excel, but the same error pops up as above. Can someone suggest a resolution please.

Answer 1

Dear HymaON

Good day! Thank you for posting in Microsoft Community. We are happy to help you.

Based on the error you got, when searching for this error, I found a related case, please check the link below, some community members have provided some suggestion, see if it helps.

cannot open query in excel, error message: excel is running into problems with the tfcofficeshim.connect.15 add-in.

Excel TFS Add-In Crashes Connecting to TFS

***Third-party Disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.

Besides, please ensure your Microsoft 365 apps are fully updated, sometime updating Office fixes issue. To check version information, open any Office app, such as Excel or Word, click File>Account, check for the info mentioned under Product Information. The latest version of Current channel is 2106 (Build 14131.20332). For other channel version info, see Update history for Microsoft 365 Apps (listed by date)

If the version is not updated as mentioned in the article, please install updates and check if the issue remains. To know how to install updates, see Install Office updates.

Also, please check if there are any update available for the add-in.

Any updates please feel free to post back. We’re looking forward to your reply and will continue to help you all the time!

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Stacey | Microsoft Community Moderator

Answer 2

Hi Stacey!

Thank you for providing guidance on my reported issue as shown in the snippet below.

This link below helped me figure the cause.

Excel TFS Add-In Crashes Connecting to TFS.

Additionally, I have referred to the following link suggested by our technical support group.

Azure DevOps Office® Integration 2019 Crashes excel when selecting projct - Visual Studio Feedback

To summarize- Clear the contents of the 'Cache' sub folders in the paths provided in the above links and re-start Excel. Please make sure to have the Team tab installed in your excel application for the integration to work. If the issue is with the Team tab disappearing, please enable the COM-Add-ins via Excel>Options. Hope this helps.

Thanks again!

Answer 3

Dear HymaON

Thank you for your quick response and we also appreciate you spent your precious time providing the updates to us.

We're happy to hear that by the information we provided above is helpful for you! Besides, we really appreciate you share the solutions and the article link in here, which will be much helpful for other users who have the same problem as yours.

If you think this is helpful, please kindly submit the feedback, this will help the other users on the community to see it more clearly.

Really appreciate your patience and understanding.

Sincerely,

Stacey | Microsoft Community Moderator