#NAME? Error in 8.83mb worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dcr - 18 Mar 2008 17:53 GMT

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

Reply to this Message

Jan Karel Pieterse - 19 Mar 2008 06:24 GMT

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

Reply to this Message

GuruGirl - 23 Mar 2008 02:27 GMT

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.

> Every 2 weeks I update an Excel file that contains macros. A few weeks ago it
> started displaying #NAME? errors in the worksheet.
[quoted text clipped - 7 lines]
>
> Thank you

Reply to this Message

Alan124 - 24 Mar 2008 15:18 GMT

On Mar 23, 9:27 am, GuruGirl <GuruG...@discussions.microsoft.com>
wrote:

> This error occurs when Microsoft Office Excel does not recognize text in a
> formula.
[quoted text clipped - 18 lines]
>
> - 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

Reply to this Message

Rate this thread: