Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Annoying error message.

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Keaau, Hawaii
    Posts
    238
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Aug 2002
    Posts
    106
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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>

  5. #5
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,836
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •