How to fix "TF80070" error while opening work items in excel?

Kishore Kadari 5 Reputation points
2025-03-25T14:31:08.09+00:00

while dealing with DevOps work items queries, when I open the work items using "open in excel" option. I see a following error, please resolve."TF80070: An error occurred while performing the operation. It is recommended that you save your work and restart the application."

Azure DevOps

1 answer

Sort by: Newest
Most helpful Newest Oldest
  1. Arko 4,185 Reputation points Moderator
    2025-03-31T08:51:50.8933333+00:00

    If you're seeing the TF80070 error while trying to open Azure DevOps work items in Excel using the Open in Excel option, it usually points to a problem with the integration between Excel and Azure DevOps. Please try below steps to narrow down your issue and troubleshoot better-

    Close Excel completely and clear any cached files used by the Team Foundation plugin. Go to:

    C:\Users\<your-username>\AppData\Local\Microsoft\Team Foundation\<version>\Cache Delete all contents inside the Cache folder. enter image description here Reopen Excel and try again. Sometimes the Team Foundation add-in gets disabled: Open Excel -> File -> Options -> Add-ins Look for Team Foundation Add-in. enter image description here

    If it’s disabled, re-enable it. Outdated or corrupted credentials or plugins can cause this issue. Open Windows Credential Manager. Remove any stored credentials related to Azure DevOps or TFS. Try connecting again, Excel should prompt you to re-authenticate. Compatibility issues between versions often cause unexpected behavior. You can refer to this documentation -Resolve common Azure DevOps Office integration issues - Azure Boards | Microsoft Learn Hope this information was helpful. Thanks.

    Was this answer helpful?

    2 people found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.