Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
Can you please edit this question and give us more detail? What version of Excel, what type of server, how is the file being executed, etc? –  CharlieRB Oct 26 '12 at 12:01
    
@CharlieRB:I have editted my answer.Please ask me if yu don`t understand. –  niveiwish Oct 26 '12 at 12:09

1 Answer 1

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.

share|improve this answer
    
Charlie:I went through this article.I have given a trusted location to where i copy files.But still same problem. –  niveiwish Oct 26 '12 at 12:56
    
Although I wasn't accessing the files in the same manner as you, I had the same problem when we upgraded to 2010 and this is how we fixed it. Have you installed all Windows & Office updates and restarted your computer? Do you still get the error with a local (on your hard drive, not on the network) copy of the file. –  CharlieRB Oct 26 '12 at 13:52
    
:Yeah i restarted system.Updated office and windows.I got to know that its failing to get cellnames of hidden columns.I dont know why it`s failing.You have any suggestions???? –  niveiwish Oct 29 '12 at 9:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.