Deleting Corrupt Names

This page in 2003
Top  Previous  Next

Sometimes OAK cannot delete/recreate names in Excel.

Sometimes it is possible to delete these names manually using Formulas | Defined Names | Name Manager. Other times it may be possible by switching to R1C1 style (Office Button | Excel Options | Formulas | Working with formulas), at which time Excel will prompt the user to change each corrupt name.

See http://support.microsoft.com/kb/555127.