#NAME? error message when I send file to other pc

[Marcy]

Can anyone please tell me why I would get a #NAME? error message when all I am doing is sending a complete workbook via email to another associate.

I checked the HELP file and it said that the NAME is not recognized but I am puzzled as to why that is. You see, I have a tab entitled "HOLIDAYS" and the formulas on the worksheet tab refer to this named range. Here is an example of a formula on this worksheet tab: =WORKDAY(C5+$B6-1,1,HOLIDAYS
C5=a start date (such as 1/7/04
B6=0 days (as the next step in the process should equal C5, in this case
And, then, as I said, I have a list of holidays on a separate tab

When I change the start date (C5) on MY pc, all works fine. But, when I sent it to two other associates, both ended up with the #NAME? error message all the way down the column. Any ideas?

 

[Dave R.]

The function WORKDAY is in the "Analysis toolpak" which is not installed on
your associates' computers.

Can anyone please tell me why I would get a #NAME? error message when all

I am doing is sending a complete workbook via email to another associate.

I checked the HELP file and it said that the NAME is not recognized but I

am puzzled as to why that is. You see, I have a tab entitled "HOLIDAYS" and
the formulas on the worksheet tab refer to this named range. Here is an
example of a formula on this worksheet tab: =WORKDAY(C5+$B6-1,1,HOLIDAYS)

C5=a start date (such as 1/7/04)
B6=0 days (as the next step in the process should equal C5, in this case)
And, then, as I said, I have a list of holidays on a separate tab.

When I change the start date (C5) on MY pc, all works fine. But, when I

sent it to two other associates, both ended up with the #NAME? error message
all the way down the column. Any ideas?

 

[Marcy]

Thank you so much! I was going out of my mind but with your kind (and swift) reply, maybe I can bring it back!!

 

[Dave R.]

Surely you can! Hopefully your associates can install that (or have the CD
to install it).

Thank you so much! I was going out of my mind but with your kind (and

swift) reply, maybe I can bring it back!!

 

[Norman Harker]

Hi Marcy!

Here's how to get Analysis ToolPak installed and selected. Sorry for
alternatives but you didn't specify what version of Excel.

If Analysis ToolPak is not installed or selected any cells containing
Analysis ToolPak functions and all dependent cells will return the
dreaded #NAME! If that happens read on. In any case, you should read
on if you are building an application that others might use especially
if used on different computers.

***Excel 2002***
Use Tools > Add-Ins

Check the Analysis ToolPak entry.

If you get no messages, press OK.

Depending upon whether its been used before and upon load on first use
options used during installation, you may get messages requiring you
to insert the setup discs.

Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.
***Excel 2000 and before***
Use Tools > Add-Ins [For old specification computers it might take a
few seconds before anything happens!]

If there is an Analysis ToolPak entry in the Options listed just put a
check against it and press OK.

If there is not an Analysis ToolPak entry you will need to close Excel
and re-run the Setup discs. You will find that Analysis Toolpak is
listed as one of the options for Excel's installation.

Once that is done you may open Excel and you'll find that it is now
listed as an Add-In when you use Tools > Add-Ins.

Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Thank you so much! I was going out of my mind but with your kind

(and swift) reply, maybe I can bring it back!!