excel 2002 - error caused by corrupted named ranges


H

hutch

Every time I group or ungroup rows or columns I get the
following error: "your file contains an invalid external
reference to a worksheet. verify the path, workbook, and
range name or cell reference are correct, and try again."
This occurs even if the active cell is empty.

Note that I have no external references on the sheet and
all external references in the workbook have been updated
and appear valid.

Only oddity is this -- my file has a named range with a
name of:

(box)(box)(box)Loan_Loss_Provision

The boxes are the symbol used for unassigned charters in
various fonts.

Any idea what is going on? The cause of the error? How
to remove the named range above?

Thanks for any help you can provide.

Cheers,


Hutch D.
 
Ad

Advertisements

J

Jan Karel Pieterse

Hi Hutch,
Only oddity is this -- my file has a named range with a
name of:

(box)(box)(box)Loan_Loss_Provision

The boxes are the symbol used for unassigned charters in
various fonts.

Any idea what is going on? The cause of the error? How
to remove the named range above?

Download the Name manager from either
www.jkp-ads.com
or
www.decisionmodels.com
or
www.bmsltd.co.uk/mvp

Install it, start it (find it in the Tools menu) and try to delete your
name. It will prompt you to fix the corrupt name.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
G

Guest

Jan Karel,

Jan! Jan! Jan! You rock!!!

Your utility is easy to use. instructions are great! It worked seamlessly!!!

The guy next to me had invested a WEEK trying to solve this problem in a large workbook...
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top