Name Box (Drop Down Box) - Excel Crashes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2003 wth SP2 from the Office Suite Pro Package. I am
trying to use the NAME Box in the Forumula bar. I can create a NAME range,
but when I attempt to select a NAME range by clicking on the drop down arrow,
my excel crashes on me.

I get a dialog box that pops up...
Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.

Then I have the option to send an error report to Microsoft regarding the
problem.

I have applied all the patches and even tried uninstalling Excel 2003
application and re-installing. Same thing happens. This is very annoying
because I would like to use the NAME Range box.

In ideas?
 
Chuck

I presume this is any file, not just one. If one then I suspect the file
rather than Excel and I would save off anything you can before it gives up
completely

If it's all files, normally, if you re-install the only thing left is you
Excel.xlb( toolbar customisation file), search (including hidden files) for
*.xlb and move it away from it's current location. (hen Excel doesn't find
one it'll create a new one. See if that cures the issue

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
Nick,
Thank you for your response. I tried what you suggested. I found a file
called Excel11.xlb and moved it to another location. I opened up my
application and noticed my toolbars are different. What I would expect
assuming this took away my previous default toolbar settings. I open up any
file that had a NAME range list defined and it still crashed on me.

BTW, I have a similar behaviour reacting the same way using a drop down box.
In happens in my outlook 2003 application. When I attempt to use the
ADDRESS BOOK under the TOOL menu option of OUTLOOK, there is a drop down box
under SHOW NAMES FROM THE LIST. If I click on the arrow pointing down and
select a contact name, my outlook crashes and gives me a similar error as the
Excel application.

The only work around for these drop down boxes is if I type in the respected
choice in the drop down box and choose it (using my enter key), it works
fine. BUT as soon as I do an ONCLICK event, it crashes on me. It seems like
some module on an ONCLICK event is corrupt. These are the only areas where I
have noticed that the drop down boxes crashes on an ONCLICK event. I know
there are other drop down boxes in these apps that seem to work fine, but
these two areas are problems.

Do you think these are related somehow. Very strange.
 
Chuck

Almost certainly, I would think *very* carefully what you have installed,
changed recently and un-install it or see if you can roll back using windows
system restore to a point you know the application worked

BTW, just replace your Excel11.xlb and the toolbar customisations will
return

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
Nick,
The problem with that scenario, is that I learned to live with the OUTLOOK
problem for a long time possibly more than a year. I called support awhile
back and they had me un-install OUTLOOK and re-install it, but it never fixed
the problem. They were puzzled so I learne to live with it. Just recently
in the last week is the first time I noticed my drop down NAME box problem
with Excel. It just happens that I remembered this same problem was
happening in my OUTLOOK Address Book drop down box too and thought they would
be related somehow. To find a good restore point would be hard to find I
guess.

Any other suggestion? Thanks for your response.
 
Chuck

Try un-installing and then look through your entire CD Rom for a file called
OffClean.exe. (I'm not sure if all versions ship with this. If you have it,
run it and it will clean all residue of Office. I have to say, I fear
another issue, but at least if you can run this you will know it's not
Office per se

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
Nick,
I un-installed my Office and ran offCln.exe. Re-installed Office, but still
getting the same errors. In your previous e-mail you say, it may be
something else...what could it be?

Thanks for your assistance so far,
Chuck
 
Chuck

And there is the million dollar question, but you can be pretty sure it's
not Office now. I would start by un-installing anything I don't use
regularly and certainly be suspicious of any beta, demos, free utilities,
etc.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top