So I wanted to add more sheets to my VSTO (Excel 2007 Workbook) C# project. I tried right clicking the xlst, parent of the sheets, but there were no options, I tied to open the xlst but the workbook would flash up in Visual studio but then go away again and excel would open saying something about an error.
Instead I checked out for edit the xlst from source and closed visual studio, I then opened the xlst file in excel and added the sheets, then saved , closed and reopened visual studio and the sheets had appeared. Woo!
