N/a Error In Excel 2003

[SUSANMLY]

I work in an office with multiple different excel versions, most of th
time things run fairly smooth. I'm running across a problem with
worksheet in excel 2002. It is being sent to a person with excel 200
on there pc and all of the figures are showing up as NA. Please advis
if there is a solution to this problem

 

[Ken Wright]

What is the formula producing this message? Is it from the analysis toolpak
addin, and do they have it installed on their PC?

 

[SUSANMLY]

How do I tell if it's from the analysis toolpak addin? I'm still tryin
to get the formula, they said it's kind of lengthy

 

[Peo Sjoblom]

If it was from the ATP it would produce the name error not #N/A
I have never had any problems with 2003 in this regard
--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Ken Wright]

Good point Peo

Ok, what about links? If the formula contains links to a file on your LAN and
you are mailing out to people outside the LAN, then I can see that happening.
Likewise, even if people have access to teh same drives, if the drives are
mapped with letters, eg: H:\, J:\, K:\ etc, and the file is created with links
to another file that for most people is on a drive with the same drive letter,
and you then have somebody open it that has that drive mapped to a different
letter, then it may well error out on you.

You really need to post the formula before we can try and give you any further
pointers.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

If it was from the ATP it would produce the name error not #N/A
I have never had any problems with 2003 in this regard
--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[SUSANMLY]

=IF($AF8=0,0,VLOOKUP($AF8,'E:\Documents and Settings\Heid
Morin\Desktop\ELC-2002\[ELC-2002.XLS]ELC Record- 02'!$B$4:$DV$10002
90,FALSE)

 

[Ken Wright]

That formula is pointing to a file ELC-2002.XLS that resides on your users
hard-drive (Desktop). If the person you send the file to does not have that
file then they will not be able to use this one. They will also likely need to
change the links to point to the file at whatever location it is to be found on
their machine, and you should be able to do Edit / Links / Change Source - then
just point to wherever the file is on their machine.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

=IF($AF8=0,0,VLOOKUP($AF8,'E:\Documents and Settings\Heidi
Morin\Desktop\ELC-2002\[ELC-2002.XLS]ELC Record- 02'!$B$4:$DV$10002,
90,FALSE))