You were the one I was quoting, but as you can see in a later post, I kind
of butchered the spelling of your name, so I hadn't attempted it here.
Sorry about the misspelling.

--
Regards,
Tom Ogilvy

"Jan Karel Pieterse" wrote in message
...
Hi Tom,

This was a hint posted in the newsgroups a while back - I
haven't had the
opportunity/need to try it.

It will work. Excel will prompt for a new (valid) name for
each corrupt one it finds (in all open workbooks!). After
that, one can delete the changed names.

Regards,

Jan Karel Pieterse
Excel TA/MVP