#NAME!

[John McGraw]

I wrote a macro that fills some columns with formulas. Simple ones, like "=H2+(H2*($H$3*D2))". It works just fine on my system, but I sent this spreadsheet to someone else and they say that they get the "#NAME!" error in every cell!

I asked them to check the formula, and tell me what it says. From what they tell me, the formula is EXACTLY as it is on my system. But for them it produces the #NAME! error.

We both are using Excel 2000. There is one difference between the versions though. He is in the UK, and I am here in the US. Could that be the problem? And if so, how could I fix it?

Thanks for any help!

 

[Mark W.]

You can trace all precedents beginning with the cell containing the formula, =H2+(H2*($H$3*D2)), back to the cell that generated the #NAME? error by using the Trace Error button on the Auditing tool bar. The Auditing tool bar found under the Tools | Auditing menu path.
This message was edited by Mark W. on 2002-03-11 15:26

 

[Jack in the UK]

Hi

I send excel 97 docs all arround the world with scripts and formulas a milluions hitch free, my friends in New York and so on dont have issues like this all is perfect.

There are many US posters that can check with luck and advise differences, that cound not defaults to $ not GBP. I mean thigs that matter

I was sent your like this in 1995 office 95 on floppy fron Canada by a charity i was helping and on 45 floppys! thats had odd things about it it was CANADIAN version, Barrie Davidson is form Canada might he know....

 

[Juan Pablo González]

You could be using formulas that come from an AddIn.