#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

 

[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