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.
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.
- 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.
- 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. - 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.
- Check the add-in is enabled (step 2 above) and not under Disabled Items.
- Repair or reinstall Azure DevOps Office Integration, then restart Windows.
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.
- If you use the Team tab, choose No. Choosing Yes disables the add-in and the Team tab disappears. If you already did, enable it again under Disabled Items (step 1 above).
- If Excel lists it under File → Info → Manage COM Add-ins (slow and disabled add-ins), choose Always enable this add-in there.
- Update or repair Azure DevOps Office Integration 2019 and install the latest Office updates, then restart Windows.
- If it comes back, clear the add-in cache (step 4 below); a corrupt cache is a common cause of the crash.
- If you don't use the Team tab, choosing Yes is harmless: Excel itself keeps working.
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:
%LOCALAPPDATA%\Microsoft\Team Foundation\8.0\Cache%LOCALAPPDATA%\Temp\Microsoft\Team Foundation\9.0\Cache
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
- The button comes from the Azure DevOps Open in Excel extension, which an organization admin has to install first.
- It hands the query to Excel on your computer, so the Office Integration add-in must be installed and working (steps 1 to 4).
- It works on query results; if nothing happens, check the add-in by opening Excel and using Team → New List directly.
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:
- Bulk edit in the query results: select several items, open the context menu and choose Edit to set one or more fields to the same value.
- CSV export and import: Export to CSV from a query, edit the file, and bring it back with Boards → Work items → Import Work Items.
- A spreadsheet grid in the browser: Bulk Editor (made by us) opens a query in an editable grid inside Azure DevOps (Services and Server 2022 or later), with paste from Excel, validation before publishing and a clean .xlsx export. Nothing to install on your computer; there is a free plan.
A longer comparison of these options: How to bulk edit Azure DevOps work items without Excel.
Related guides
- How to bulk edit Azure DevOps work items without Excel
- Azure DevOps work items in Excel on a Mac
- Azure DevOps Open in Excel alternatives (2026)
- Bulk Editor: features, pricing and free plan