BOM Error

Recently, within the past few weeks, when trying to import an en excel based BOM I get an error "close method of workbook failed." This seems to be pretty common. There's another thread here now with the same thing and I saw another last week so something must have changed somewhere causing it.  

So ok, no big deal. I can just use the regular BOM instead. I've already set the layout on that last year we just had always used the excel style but can transition. I like the excel format anyway. However when going to insert the BOM I get an error saying "This drawings contains an excel-based BOM..To insert a SW based BOM first delete the excel-based version." 

How do I delete the excel version? The table never showed up due to the first error. I don't see anything on the feature manager. If I delete the sheet and make a new one I still get an error saying the excel one is in an inactive sheet. I don't want to have to redo the entire drawing because of this.

SolidworksDrawings And Detailing