CODEWITHSUNDEEP
exceltfs
Pat Delaney
Pat Delaney

Reputation: 117

How to re link Excel spreadsheet to TFS after a project name change

We recently had to rename a Project in TFS 2018, That went well as expected. I have a user that is using the Excel plugin for TFS and their excel document no longer can pull data from TFS. Is there anyway to fix it to reconnect to the new project name? It's not a simple spread sheet. There are a lot of tabs that have inter dependencies on the tabs that can run TFS queries.

Thanks for your help

Upvotes: 0

Views: 381

Answers (1)

Kevin Lu-MSFT
Kevin Lu-MSFT

Reputation: 35574

Is there anyway to fix it to reconnect to the new project name?

Based on my test , when I change the TFS 2018 Project name, I could reconnect to the new project name in the following two ways.

  1. Use the "Refresh" option in the Excel.

Project

2.Reconnect the TFS and find the New Project name in Configure -> Sever connection. Then select the new project to connect.

In this case, you may get this error message.

error

To solve this issue, I try to restart excel and repeat the same connection steps. Then it could work.

Update:

You could try to delete the VS Team Records in Excel -> Files -> Info -> Properties ->Advanced Properties -> Custom.

enter image description here

Then you could connect the new Projects.

Upvotes: 0

Related Questions