Results 1 to 5 of 5
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ambiguous name error locks Excel (Excel 2000)

    Hi all,
    I've searched the forums for all posts on 'ambiguous name' and none of them mention the error I see.

    I was renaming text boxes in a form and accidently duplicated the name of one field. Ok, no big deal I can fix that, but NOOOOO, Excel is now locked up with the error message:

    "Could not set the Name property. Ambiguous Name." It has two buttons, [OK] <img src=/S/help.gif border=0 alt=help width=23 height=15> but the cursor is a circle with line through it and you can't do anything, can't click OK, can't quit or exit <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15>

    I've had this happen several times and the only way out is to kill from task manager. According to the task manager, Excel is running and the system idle process is at 95% so the system is happily doing nothing.

    Is this a known bug, it's so frustrating!! <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    Deb

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ambiguous name error locks Excel (Excel 2000)

    Thanks for the MSKB reference. I did try the ESC key but it didn't work. I had this happen a few times. The article mentioned pressing Enter after entering the name which I don't usually do so I'll try and pick up that habit.

    Thnx, Deb <img src=/S/sailing.gif border=0 alt=sailing width=25 height=25>

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ambiguous name error locks Excel (Excel 2000)

    If possible, try saving the file, closing it and then reopen the file. I have found that this releases the duplicated textbox name.

    John

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ambiguous name error locks Excel (Excel 2000)

    <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> Yes, I tried that too. No keys worked, I couldn't save, quit, break, escape - nothing. I'll remember these things you and the other poster mentioned for next time it happens

    Just now I opened a new/blank workbook and tried to duplicate it intentionally and couldn't. I added a form with two buttons that had the same name. After entering the duplicate name on button 2, I did get the 'ambiguous name' error message, but the cursor was not the circle with a line through it. I was able to press OK and just continue.

    Dunno why it locks up on me... yet another reason to save often and to save your code modules separately (in case Excel decides to <img src=/S/puke.gif border=0 alt=puke width=60 height=15> next time you want to open the file).

    Thnx, Deb <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  5. #5
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Re: ambiguous name error locks Excel (Excel 2000)

    Deb,
    I did a quick search in the MSKB for "ambiguous name" and found Q220613 which matches the problem exactly.

    It says that if you press Esc your cursor will return to normal!

    Jeremy

Posting Permissions

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