If any user complains of excel error Microsoft Visual Basic Error - “ System Error & H8004005(-2147467259) Unspecified error”or user receives error always like FILE LOCKED FOR EDITING BY ANOTHER USER even though no user has opened file in filer, Please follow below steps to resolve issue.
1.Close all excel sheets
2. Open a new excel file ,go to file ,–excel options,-Add ins
3. Click on go
4. If Conditional Sum Pack is checked ,please uncheck ,click ok & close excel .