'NAME' instead of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

If you mean

#NAME?

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

Mike
 
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?
 
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
 
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...
 
Back
Top