File in use excel 2k7

What are reason that causes the file in use in Microsoft Office 2007. We have tried different machines and yet, we encounter problems in excel 2007 only "File in use" when opening a certain file with macro and without macro. What needs to be done to avoid this from happening.
 

Question Info


Last updated February 21, 2018 Views 220 Applies to:
Answer
Normally you get this message if "Open" file association for XLS is set for DDE  and  there
is a %1 at the end Excel command line. This is viewed via Windows
Explorer->Tools->Folder Options->File Types, pick XLS and click Advanced.
If you have that you can unselect DDE.

Also pls refer to this blog, it may help

Weird "File in Use" error opening Excel 2007 Files on the network.
http://answers.microsoft.com/en-us/office/forum/office_2007-excel/weird-file-in-use-error-opening-excel-2007-files/887e002d-1158-4a0b-9de8-931e473469d8

You receive a message when you try to open an Excel 2007 document on a Windows Vista-based computer from a remote shared folder, even if no other user is using the document: "File in use"
http://support.microsoft.com/kb/942146
Like to answer questions which aren't answered for long time.

Excelee.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.