Question posted 2011 · +10 upvotes
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.
Accepted answer +15 upvotes
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.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 25%.