Can you give more detail. I was unable to reproduce it as far as I
understood.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"K" wrote in message
...
I have a question. I had every one on my team install the add ins and it
works fine until one of them filters the data by the auto filters set up
then
all of the formulas containing workdays/networkdays give a #Name? error.

"Bob Phillips" wrote:

No, don't do that. Just the Analysis Toolpak will be fine in 90% of
situations.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"BLOTTY" wrote in message
...
Thanks fellas, that was it. Should I tell my IT department to turn on
all
these add-ins or could this cause problems???

"BLOTTY" wrote:

I CREATED A WORKSHEET WHICH TAKES A GIVEN DATE, SUBTRACTS A NUMBER OF
GIVEN
DAYS AND A STANDARD NUMBER OF DAYS TO OUTPUT AN EARLIER DATE (NOT
INCLUDING
WEEKENDS) WHEN OTHERS TRY TO USE IT ON DIFFERENT PC'S, SOME GET A
"#NAME?"
ERROR AND WHILE OTHERS IT WORKS FOR.

THE FORMULA I USED IS:

=WORKDAY(B4,-C4-3)
B4=01/01/07 (DATE FORMAT 3/14/01)
C4=1 (NUMBER FORMAT 0 DECIMAL PLACES)