#NAME? Error showing up when it shouldn't be

Hi,

So I have yet another issue. I created a report for use at work, but when I emailed it out - someone is having issues viewing it. The formulas are all showing #NAME? errors. Now, this user has excel 2010 and I've tested this and sent it to another user that also has 2010 and it shows up perfectly.

I know that this error usually shows up when a newer formula is used on an older version of excel that doesn't recognize the formula.

Even more puzzling is that I don't think that I used any formulas that would cause problems - Here they are:

=SUBTOTAL(9,V2:V4)
=VLOOKUP(B5,DOCT14MOVES,4,FALSE)
=SUBTOTAL(1,Y2:Y4)
=ROUND((U5+AA5)/Z5,2)&" Months"

Is it possible that there is a setting that is causing this to happen? Or maybe its not recognizing the named range (Even though its part of the file)?

Thanks!

I wish I could, but work restrictions being what they are - I can't. I realize that hinders the amount of help you can provide, but I don't really have any other options.

I should also add that the entire report is subtotaled with certain columns containing formulas that are copied to the visible cells only - I do this regularly and have never run into any issues.

I'm a bit flummoxed by this - the only thing I can think of is that it is an issue with the individuals's user settings, since it works in every other situation.

The file is also "Read Only" - if that makes any difference.

I tried mine on manual, it still didn't give me any errors - just required manual calculation updates.

Originally Posted by FDibbins

The bolded 1 looks promising?

+1

Though the Analysis Toolpack Addin is installed by default in XL2010, it is possible to remove it.

Unintentional duplicate...
Moderators please delete.