Annoying error message.

[Q45]

Whenever I open Excel I get the following annoying message: "Insert Visio Button.XLS is locked for editing by 'xxxxx'. Click Notify to open as a read-only copy of the document and receive notification when the document is no longer in use."
My option buttons are "Read Only," "Notify," and "Cancel." How do I stop this from poping up everytime? Thanks.

 

[Dave Hawley]

Hi

Try using a macro to open it like:

Workbooks.Open Filename:= _
"C:OzGridFinanceIncome & Expenditure Client Database NEW.xls", Notify:= _
False


With "Notify:=False" being the key. This will default it to read-only

 

[KniteMare]

This could also be a NetWork Problem. Assuming the file is not acually open by User "xxxxx" or user "xxxxxx" is not you and you do not have the file open in another location. Then When Excel Performs and illegal operation and shutsdown while a file is open some networks cannot see that the file is closed and will incorrectly tell you it is open and you get this message. So if your on a network and have an MIS or Help Desk, contact them and have them free the file up by manually closing it on the network. This will make the message go away until the next time Excel GPF's.

 

[MarkHenri]

Most likely, it's an item with macros in it in one of your xlstart folders. Search for xlstart in the file find utility and go into each folder and clear out the items. Renaming won't do, they need to be moved out. This should stop this annoying message.

If this still doesn't solve the problem, call the Microsoft Excel Technical Support Group. Since you get two free incidents of support with your Office product, it's the easiest, quickest way to get a resolution to this problem. Their number is 425-635-7056. The customer service agent will connect you to a friendly, helpful technician that will resolve this problem and get you up and running quickly.

 

[starl]

Is it a corrupt add-in? or an add-in based of a network? You can view your add-ins in: Tools - Add-ins.