JR DevTools logoJR DevTools

Azure DevOps Excel add-in not working? Fix the missing Team tab

Editing work items in Excel, and the Open in Excel button, both depend on the Azure DevOps Office Integration add-in. It's a COM add-in for Excel on Windows, and most problems come down to it being missing, disabled or holding a stale cache. Here are the fixes, roughly in the order you should try them.

Rather skip the add-in? Bulk Editor lets you edit work items in a spreadsheet-like grid in the browser, on Windows and Mac.
Install from the Marketplace See how it works Watch the 1-minute video

1. There is no Team tab in Excel

The Team tab isn't part of Office; the add-in adds it.

  1. Install Azure DevOps Office Integration 2019. It's a free download on the Visual Studio downloads page, and it's also installed with Visual Studio when you select the Office integration component. Close Excel while it installs.
  2. Open Excel and go to File → Options → Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Tick Team Foundation Add-in. The add-in file is TFSOfficeAdd-in.dll.
  3. If it isn't in that list, choose Disabled Items in the same Manage list. Excel can disable an add-in after it caused a crash; enable it there and restart Excel.

The Team tab only exists in the desktop version of Excel on Windows. Excel for the web and Excel for Mac don't support the add-in at all; see Azure DevOps work items in Excel on a Mac.

2. TF80012: "The document cannot be opened because there is a problem with the installation"

This usually means Excel can't load the add-in that the workbook was created with.

3. "Excel is running into a problem with the 'tfcofficeshim.connect.16' add-in"

The full message is "Excel is running into a problem 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?" TFCOfficeShim.Connect.16 is the part of the Azure DevOps Office Integration add-in that Excel loads at start-up. Excel shows this message when the add-in crashed or made Excel start slowly.

4. Excel crashes or hangs right after you sign in

A common cause is a corrupt local cache of the add-in. Close Excel, delete the contents of these folders, and try again:

If it only fails for one organization, also remove the saved credentials for dev.azure.com in Windows Credential Manager, so the add-in asks you to sign in again.

5. "Open in Excel" does nothing or isn't there

Still stuck? Edit the work items without the add-in

If you mainly want to change many work items at once, you don't need Excel for it:

A longer comparison of these options: How to bulk edit Azure DevOps work items without Excel.

Install Bulk Editor

Related guides

Not affiliated with Microsoft. “Azure DevOps”, “Excel” and “Office” are trademarks of Microsoft. Questions? Email support@jr-devtools.com.