#NAME!

John McGraw · Mar 11th, 2002, 02:34 PM

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. · Mar 11th, 2002, 04:24 PM

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 · Mar 11th, 2002, 04:29 PM

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 · Mar 11th, 2002, 05:43 PM

You could be using formulas that come from an AddIn.

Mar 11th, 2002, 04:29 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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.... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 11th, 2002, 05:43 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You could be using formulas that come from an AddIn. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 02:34 PM	#1
John McGraw Board Regular Join Date: Feb 2002 Posts: 76	I wrote a macro that fills some columns with formulas. Simple ones, like "=H2+(H2($H$3D2))". 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!

Mar 11th, 2002, 04:24 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You can trace all precedents beginning with the cell containing the formula, =H2+(H2($H$3D2)), 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 ]