I have an Excel sheet which is generated by opening the result from some query based on TFS work items.
我有一个Excel表，它是由基于TFS工作项的查询打开结果生成的。
I'm using this Excel for my personal planning, but whenever I close the Sheet, it asks me if I want to publish my changes to TFS.
我正在使用这个Excel进行个人计划，但是每当我关闭这个表时，它会问我是否想要将我的更改发布到TFS。
I want it to completely forget that it is derived from TFS, because I fear that some day I may publish my changes unintentionally.
我希望它完全忘记它来自TFS，因为我担心有一天我可能会无意地发布我的更改。
I have tried saving the Excel Document in the oldest possible Excel format, but that doesn't help.
我试过用最古老的Excel格式保存Excel文档，但这并没有帮助。
3 个解决方案
#1
9
You can copy the list and paste it into another Excel workbook.
您可以复制列表并将其粘贴到另一个Excel工作簿中。
#2
22
This is much easier than the other solutions on offer:
这比提供的其他解决方案要容易得多:
- Click on a cell in the table
- 单击表中的单元格
- Open the Table Design tab on the ribbon
- 打开缎带上的表设计选项卡
- Click "Convert table to range"
- 点击“转换表到范围”
- Save the workbook
- 保存工作簿
Done!
完成了!
Disclaimer: I've only tried it with TFS 2012 & Office 2010.
免责声明:我只尝试过TFS 2012和Office 2010。
#3
2
There is a procedure that describes how to do this at this Microsoft blog, provided by Dennis Habib:
有一个程序描述如何在这个微软博客上这样做，由Dennis Habib提供:
"Close Excel. Disable the TFS addin by going to HKLM\Software\Microsoft\Office\Excel\Addins\TfcOfficeShim.Connect and change the ‘LoadBehavior’ from ‘3’ to ‘0’. Open the .xls file. Wipe out the contents of the custom document properties (File -> Properties -> Custom). Save the file and exit Excel. Re-enable the TFS addin."
“Excel。禁用TFS插件，进入HKLM\软件\Office\Excel\Addins\TfcOfficeShim。连接并更改' LoadBehavior '从' 3 '变为' 0 '。打开xls文件。清除自定义文档属性的内容(文件->属性->自定义)。保存文件并退出Excel。启用TFS外接程序。”
#1
9
You can copy the list and paste it into another Excel workbook.
您可以复制列表并将其粘贴到另一个Excel工作簿中。
#2
22
This is much easier than the other solutions on offer:
这比提供的其他解决方案要容易得多:
- Click on a cell in the table
- 单击表中的单元格
- Open the Table Design tab on the ribbon
- 打开缎带上的表设计选项卡
- Click "Convert table to range"
- 点击“转换表到范围”
- Save the workbook
- 保存工作簿
Done!
完成了!
Disclaimer: I've only tried it with TFS 2012 & Office 2010.
免责声明:我只尝试过TFS 2012和Office 2010。
#3
2
There is a procedure that describes how to do this at this Microsoft blog, provided by Dennis Habib:
有一个程序描述如何在这个微软博客上这样做，由Dennis Habib提供:
"Close Excel. Disable the TFS addin by going to HKLM\Software\Microsoft\Office\Excel\Addins\TfcOfficeShim.Connect and change the ‘LoadBehavior’ from ‘3’ to ‘0’. Open the .xls file. Wipe out the contents of the custom document properties (File -> Properties -> Custom). Save the file and exit Excel. Re-enable the TFS addin."
“Excel。禁用TFS插件，进入HKLM\软件\Office\Excel\Addins\TfcOfficeShim。连接并更改' LoadBehavior '从' 3 '变为' 0 '。打开xls文件。清除自定义文档属性的内容(文件->属性->自定义)。保存文件并退出Excel。启用TFS外接程序。”