Name Box (Drop Down Box) - Excel Crashes

[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?

 

[Nick Hodge]

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

 

[Guest]

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.

 

[Nick Hodge]

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

 

[Guest]

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.

 

[Nick Hodge]

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

 

[Guest]

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

 

[Nick Hodge]

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