'NAME' instead of numbers

L

lena

My workbook works perfectly but on some other computers they see 'NAME' in
some areas. Why?
 
G

Gary''s Student

Usually means a function can't be found. Usually its something in the
Analysis PaK
 
M

Mike H

Hi,

If you mean

#NAME?

this occurs when your formula refers to named range that doesn't exist.

Mike
 
L

lena

But if it works perfectly for me, and I email it to someone else why won't it
work for them? Why would the named range not exist for them?
 
N

Niek Otten

Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Usually means a function can't be found. Usually its something in the
| Analysis PaK
| --
| Gary''s Student - gsnu200755
|
|
| "lena" wrote:
|
| > My workbook works perfectly but on some other computers they see 'NAME' in
| > some areas. Why?
| > --
| > lena
 
M

Mike H

maybe in another workbook

lena said:
But if it works perfectly for me, and I email it to someone else why won't it
work for them? Why would the named range not exist for them?
Click to expand...
 
Top