When I try to deploy my BAM activity and view, I receive the following error:
ERROR: Failed to open BAM Excel workbook file – “D:\temp\BAMWorkbook.xls”. Old format or invalid type library. (Exception from HResult: 0x80028018 (TYPE_E_INVDATAREAD))
Just a wild guess – did you save it in the Office 2007 format instead of the old standard format?
Also, as a get-around, if you are in a hurry, you can do BAM Export to XML from the spreadsheet. The BAM utilities can read the spreadsheet or the XML file.