> Do you have a default workbook set? It's possible that it's been
> corrupted.
Never created a default workbood set. Am now using a new, minimal
install (as far as the installation will let me).
> A Personal Macro Workbook in the startup folder?
Not sure what you mean by startup folder -- OS startup (login)? Excel
startup? In any case, I haven't created or knowingly populated such a
folder.
> Any add-ins running?
No Excel add-ins running.
> Are the named ranges you *can* add static or dynamic?
Problem is the same whether I add static or dynamic names. The menu
command opens and behaves normally for two or three times. I can do
anything I want -- add, remove, etc. -- while dialog is open. But
after the magic number (which varies a bit, but usally three), Excel
hangs a moment, then quits. As I said, this happens with a new
installation and on brand new worksheets or one of the Excel ready-
made templates.
hgs
JE McGimpsey - 16 Oct 2007 18:10 GMT
> Problem is the same whether I add static or dynamic names. The menu
> command opens and behaves normally for two or three times. I can do
[quoted text clipped - 3 lines]
> installation and on brand new worksheets or one of the Excel ready-
> made templates.
Since you're not running any macros, and you've deleted your
preferences, I'm out of ideas. Usually things that cause crashes cause
them the first time, not the third.
Frankly, I'm left with guessing it's something like a haxie, or perhaps
a virus scanner causing problems, but I don't know which ones or how.
OakRidgeDr@gmail.com - 17 Oct 2007 18:46 GMT
> Since you're not running any macros, and you've deleted your
> preferences, I'm out of ideas. Usually things that cause crashes cause
> them the first time, not the third.
>
> Frankly, I'm left with guessing it's something like a haxie, or perhaps
> a virus scanner causing problems, but I don't know which ones or how.
I think you are right. I did a new install of Tiger on a spare
partition, then drag installed Excel X. Tested spreadsheets for a
while. Then installed all Mac OS updates. Tested more spreadsheets.
Finally the last Excel X update, and more testing. No problems opening
the Name>Define, creating, deleting names, whatever. Looks like I'm
due for a major OS cleanup or reinstall on my main volume.
Thanks to those of you who replied and offered your suggestions. They
all helped me.
hgs
CyberTaz - 17 Oct 2007 19:24 GMT
The first thing to try is Disk Utility - Repair Disk (or comparable 3rd
party such as Disk Warrior, TechTool Pro or Drive Genius if you have one of
them).

Signature
Regards |:>)
Bob Jones
[MVP] Office:Mac
>> Since you're not running any macros, and you've deleted your
>> preferences, I'm out of ideas. Usually things that cause crashes cause
[quoted text clipped - 14 lines]
>
> hgs