Annoying error message.

Q45 · Mar 12th, 2002, 08:21 AM

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 · Mar 12th, 2002, 08:29 AM

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 · Mar 12th, 2002, 10:19 AM

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 · Aug 18th, 2002, 03:33 PM

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 · Aug 18th, 2002, 04:48 PM

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

Aug 18th, 2002, 03:33 PM	#4
MarkHenri Board Regular Join Date: Aug 2002 Posts: 106	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. __________________ <font size="-1">Mark Henri</font> <font size="-2">Microsoft Tier 1 Excel Support Technician</font>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:21 AM	#1
Q45 New Member Join Date: Feb 2002 Posts: 32	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.

Mar 12th, 2002, 08:29 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 12th, 2002, 10:19 AM	#3
KniteMare Board Regular Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	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.

Aug 18th, 2002, 04:48 PM	#5
starl Administrator Join Date: Aug 2002 Location: Everywhere! Posts: 4,494	Is it a corrupt add-in? or an add-in based of a network? You can view your add-ins in: Tools - Add-ins.