Menu
I have an Excel sheet which is generated by opening the result from some query based on TFS work items.
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.
I want it to completely forget that it is derived from TFS, because I fear that some day I may publish my changes unintentionally.
I have tried saving the Excel Document in the oldest possible Excel format, but that doesn't help.
870
In all other Excel versions: click File > Options. In the Save category, under Save Workbooks, in the Save files in this format list, click the file format that you want to use. Tip: For more information, see File formats that are supported in Excel.
csv) saves only the text and values as they are displayed in cells of the active worksheet. All rows and all characters in each cell are saved. Columns of data are separated by commas, and each row of data ends in a carriage return.
This is much easier than the other solutions on offer:
Done!
Disclaimer: I've only tried it with TFS 2012 & Office 2010.
94
You can copy the list and paste it into another Excel workbook.
34
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
