Why does Office 2010 fail to open an Excel file?

▲
5
▼

I have a excel file I've put on a file server. When required i access it via a dll, fill it with some data in background only (through ExecuteExcel functionality).

It used to work before. Recently I changed 2003 office to 2010 office version. After that it started throwing below error.

System.Runtime.InteropServices.COMException (0x80070BBC): Office has detected a problem with this file. To help protect your computer this file cannot be opened.

Even now also it works sometimes, and sometime throws above error.

What is the problem here?

microsoft-excel
microsoft-excel-2010
microsoft-office-2010
asked on Super User Oct 26, 2012 by niveiwish • edited Oct 26, 2012 by CharlieRB

2 Answers

▲
2
▼

Office 2010 file validation requires files or file locations to be trusted. Here is a knowledge base article about it - Error message in Microsoft Office 2010: "Office has detected a problem with this file".

Try adding the location of the file to trusted locations in File > Options > Trust Center > Trust Center Settings > Trusted Locations

Add, remove, or modify a trusted location for your files.

answered on Super User Oct 26, 2012 by CharlieRB
▲
0
▼

I have got the same trouble in Office 2013. My ASPX application is through Excell Interop trying to open XLS file. But fails. Problem occurs when the file is somehow identified as dangerous and Excell try open it in "safe mode". (could be for old XLS file, macros etc.) But method Excell.Workbooks.Open need exclusive access insted of "safe mode". So an error COMException (0x80070BBC) is invoked.

Solution: For me helped finaly this: 1) Change Excell setting according security (macros, etc.) under selected user (with local administrator rights). 2) A new application pool was created in IIS and set for the APSX application 3) The application pool Identity was changed to the user from step 1) 4) Restart IIS

answered on Super User May 19, 2017 by user729893

User contributions licensed under CC BY-SA 3.0