#NAME? Error in 8.83mb worksheet

[dcr]

Every 2 weeks I update an Excel file that contains macros. A few weeks ago it
started displaying #NAME? errors in the worksheet.

A few months ago, when the file size was 5mb it worked fine. Now is it
8.83mb and it displays these errors instead of the result of a formula. The
formulas are =SF_1N(1,B11,etc) and simple Sum total cells. The error #NAME?
does not appear in all cells with formulas.

Is this related to the size of the file? Can this be fixed?

Thank you

 

[Jan Karel Pieterse]

Hi Dcr,

A few months ago, when the file size was 5mb it worked fine. Now is it
8.83mb and it displays these errors instead of the result of a formula. The
formulas are =SF_1N(1,B11,etc) and simple Sum total cells. The error #NAME?
does not appear in all cells with formulas.

SF_1N is not a built-in function, but a User Defined function that should
either be in the workbook's VBA project or maybe in an addin. In any case,
Excel cannot find this function, or it returns this error as a result.
Excel will propagate the error to all cells that use the root cause cell of an
error, so make sure you use the formula auditing toolbar to hunt down the
"root" cell(s)(tools, formula auditing).

Another possible cause is a range name that has been removed but is still used
in a formula.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[GuruGirl]

This error occurs when Microsoft Office Excel does not recognize text in a
formula.

The size of the file is not the issue. Something has changed the text
reference in a formula, possibly a "find and replace" for instance. Check
out the formulas and see if a change to the formula.

if your file was fine before, it will be fine again.

 

[Alan124]

This error occurs when Microsoft Office Excel does not recognize text in a
formula.

The size of the file is not the issue.  Something has changed the text
reference in a formula, possibly a "find and replace" for instance.  Check
out the formulas and see if a change to the formula.

if your file was fine before, it will be fine again.








- Show quoted text -

Hi,

Perhaps your file is corrupt or something. You may try some Excel file
recovery tools, such as Advanced Excel Repair to repair your Excel
file.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan