Workdays/Networkdays #Name? Error

K

K

I have a question. I have a couple of columns using nested if statements
with workdays and networkdays function.

Everything works fine on my computer, but when one of my team member
recently opened it on their comp, the columns were calculating fine until
they autofiltered a column upon which they got the #Name? error and then even
when they unfilter it does not go back.

I had every one on my team install the add ins for the toolpack etc.
 
F

Fred Smith

In Help on Networkdays, you will find that the Analysis Toolpak needs to be
installed for it to work.

Install this addon, and your #Name?s will disappear.

Regards,
Fred.
 
K

K

It's already installed.

Fred Smith said:
In Help on Networkdays, you will find that the Analysis Toolpak needs to be
installed for it to work.

Install this addon, and your #Name?s will disappear.

Regards,
Fred.
Click to expand...
 
K

K

The following:
=IF(OR($E15="",$Q15=""),"",IF(NETWORKDAYS($Q15,$E15,Holidays)<=2,"Met","Missed"))

=IF(AND($E15<>"",$C15<>"",$A15<>"R"),IF(LEFT($C15,2)="CM",WORKDAY($E15,9,Holidays),WORKDAY($E15,4,Holidays)),"")

=IF(OR($E15="",$K15="",$L15=""),"",IF(AND(LEFT($C15,2)<>"CM",LEFT($C15,2)="RA",NETWORKDAYS($E15,$L15,Holidays)<=5),"Met",IF(AND(LEFT($C15,2)="CM",NETWORKDAYS($E15,$L15,Holidays)<=10),"Met","Missed")))

Please keep in mind these formulas are working fine on everybody elses
computers!
 
D

Dave Peterson

Is that analysis toolpak installed on your pc or the pc with the trouble?

If it's already installed on the troublesome pc, then turn it off and turn it
back on. Maybe that would help.
 
K

K

LOL I tried that. I think there is something wrong with her excel. I'm
thinking at this point to call IT support and have them reinstall it or
rollback to a version that worked. It used to work fine and all of a sudden
this issue came up.

I love excel, but dang if it's not crabby!!
 
D

Dave Peterson

And if you try a simple =networkday() formula in a brand new workbook on that
other pc, does it work?
 
N

Niek Otten

The #NAME error might also be caused by the "Holidays" name.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| And if you try a simple =networkday() formula in a brand new workbook on that
| other pc, does it work?
|
|
|
| K wrote:
| >
| > LOL I tried that. I think there is something wrong with her excel. I'm
| > thinking at this point to call IT support and have them reinstall it or
| > rollback to a version that worked. It used to work fine and all of a sudden
| > this issue came up.
| >
| > I love excel, but dang if it's not crabby!!
| >
| > "Dave Peterson" wrote:
| >
| > > Is that analysis toolpak installed on your pc or the pc with the trouble?
| > >
| > > If it's already installed on the troublesome pc, then turn it off and turn it
| > > back on. Maybe that would help.
| > >
| > > K wrote:
| > > >
| > > > It's already installed.
| > > >
| > > > "Fred Smith" wrote:
| > > >
| > > > > In Help on Networkdays, you will find that the Analysis Toolpak needs to be
| > > > > installed for it to work.
| > > > >
| > > > > Install this addon, and your #Name?s will disappear.
| > > > >
| > > > > Regards,
| > > > > Fred.
| > > > >
| > > > > | > > > > >I have a question. I have a couple of columns using nested if statements
| > > > > > with workdays and networkdays function.
| > > > > >
| > > > > > Everything works fine on my computer, but when one of my team member
| > > > > > recently opened it on their comp, the columns were calculating fine until
| > > > > > they autofiltered a column upon which they got the #Name? error and then
| > > > > > even
| > > > > > when they unfilter it does not go back.
| > > > > >
| > > > > > I had every one on my team install the add ins for the toolpack etc.
| > > > > >
| > > > > >
| > > > >
| > > > >
| > >
| > > --
| > >
| > > Dave Peterson
| > >
|
| --
|
| Dave Peterson
 
N

Niek Otten

I understand that. But the #NAME error can be caused either by the function name or by the range name. I don't see any other
possible cause.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| "Holidays" is a defined range in my workbook.
|
| "Niek Otten" wrote:
|
| > The #NAME error might also be caused by the "Holidays" name.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | And if you try a simple =networkday() formula in a brand new workbook on that
| > | other pc, does it work?
| > |
| > |
| > |
| > | K wrote:
| > | >
| > | > LOL I tried that. I think there is something wrong with her excel. I'm
| > | > thinking at this point to call IT support and have them reinstall it or
| > | > rollback to a version that worked. It used to work fine and all of a sudden
| > | > this issue came up.
| > | >
| > | > I love excel, but dang if it's not crabby!!
| > | >
| > | > "Dave Peterson" wrote:
| > | >
| > | > > Is that analysis toolpak installed on your pc or the pc with the trouble?
| > | > >
| > | > > If it's already installed on the troublesome pc, then turn it off and turn it
| > | > > back on. Maybe that would help.
| > | > >
| > | > > K wrote:
| > | > > >
| > | > > > It's already installed.
| > | > > >
| > | > > > "Fred Smith" wrote:
| > | > > >
| > | > > > > In Help on Networkdays, you will find that the Analysis Toolpak needs to be
| > | > > > > installed for it to work.
| > | > > > >
| > | > > > > Install this addon, and your #Name?s will disappear.
| > | > > > >
| > | > > > > Regards,
| > | > > > > Fred.
| > | > > > >
| > | > > > > | > | > > > > >I have a question. I have a couple of columns using nested if statements
| > | > > > > > with workdays and networkdays function.
| > | > > > > >
| > | > > > > > Everything works fine on my computer, but when one of my team member
| > | > > > > > recently opened it on their comp, the columns were calculating fine until
| > | > > > > > they autofiltered a column upon which they got the #Name? error and then
| > | > > > > > even
| > | > > > > > when they unfilter it does not go back.
| > | > > > > >
| > | > > > > > I had every one on my team install the add ins for the toolpack etc.
| > | > > > > >
| > | > > > > >
| > | > > > >
| > | > > > >
| > | > >
| > | > > --
| > | > >
| > | > > Dave Peterson
| > | > >
| > |
| > | --
| > |
| > | Dave Peterson
| >
| >
| >
 
N

Niek Otten

Does any of the other PCs have a different language version of Excel? ATP functions are not translated automatically, like the
built-in functions do.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| "Holidays" is a defined range in my workbook.
|
| "Niek Otten" wrote:
|
| > The #NAME error might also be caused by the "Holidays" name.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | And if you try a simple =networkday() formula in a brand new workbook on that
| > | other pc, does it work?
| > |
| > |
| > |
| > | K wrote:
| > | >
| > | > LOL I tried that. I think there is something wrong with her excel. I'm
| > | > thinking at this point to call IT support and have them reinstall it or
| > | > rollback to a version that worked. It used to work fine and all of a sudden
| > | > this issue came up.
| > | >
| > | > I love excel, but dang if it's not crabby!!
| > | >
| > | > "Dave Peterson" wrote:
| > | >
| > | > > Is that analysis toolpak installed on your pc or the pc with the trouble?
| > | > >
| > | > > If it's already installed on the troublesome pc, then turn it off and turn it
| > | > > back on. Maybe that would help.
| > | > >
| > | > > K wrote:
| > | > > >
| > | > > > It's already installed.
| > | > > >
| > | > > > "Fred Smith" wrote:
| > | > > >
| > | > > > > In Help on Networkdays, you will find that the Analysis Toolpak needs to be
| > | > > > > installed for it to work.
| > | > > > >
| > | > > > > Install this addon, and your #Name?s will disappear.
| > | > > > >
| > | > > > > Regards,
| > | > > > > Fred.
| > | > > > >
| > | > > > > | > | > > > > >I have a question. I have a couple of columns using nested if statements
| > | > > > > > with workdays and networkdays function.
| > | > > > > >
| > | > > > > > Everything works fine on my computer, but when one of my team member
| > | > > > > > recently opened it on their comp, the columns were calculating fine until
| > | > > > > > they autofiltered a column upon which they got the #Name? error and then
| > | > > > > > even
| > | > > > > > when they unfilter it does not go back.
| > | > > > > >
| > | > > > > > I had every one on my team install the add ins for the toolpack etc.
| > | > > > > >
| > | > > > > >
| > | > > > >
| > | > > > >
| > | > >
| > | > > --
| > | > >
| > | > > Dave Peterson
| > | > >
| > |
| > | --
| > |
| > | Dave Peterson
| >
| >
| >
 
N

Niek Otten

Or has the faulty PC only Analysis Toolpak-VBA checked, not both references to Analysis Toolpak?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| "Holidays" is a defined range in my workbook.
|
| "Niek Otten" wrote:
|
| > The #NAME error might also be caused by the "Holidays" name.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | And if you try a simple =networkday() formula in a brand new workbook on that
| > | other pc, does it work?
| > |
| > |
| > |
| > | K wrote:
| > | >
| > | > LOL I tried that. I think there is something wrong with her excel. I'm
| > | > thinking at this point to call IT support and have them reinstall it or
| > | > rollback to a version that worked. It used to work fine and all of a sudden
| > | > this issue came up.
| > | >
| > | > I love excel, but dang if it's not crabby!!
| > | >
| > | > "Dave Peterson" wrote:
| > | >
| > | > > Is that analysis toolpak installed on your pc or the pc with the trouble?
| > | > >
| > | > > If it's already installed on the troublesome pc, then turn it off and turn it
| > | > > back on. Maybe that would help.
| > | > >
| > | > > K wrote:
| > | > > >
| > | > > > It's already installed.
| > | > > >
| > | > > > "Fred Smith" wrote:
| > | > > >
| > | > > > > In Help on Networkdays, you will find that the Analysis Toolpak needs to be
| > | > > > > installed for it to work.
| > | > > > >
| > | > > > > Install this addon, and your #Name?s will disappear.
| > | > > > >
| > | > > > > Regards,
| > | > > > > Fred.
| > | > > > >
| > | > > > > | > | > > > > >I have a question. I have a couple of columns using nested if statements
| > | > > > > > with workdays and networkdays function.
| > | > > > > >
| > | > > > > > Everything works fine on my computer, but when one of my team member
| > | > > > > > recently opened it on their comp, the columns were calculating fine until
| > | > > > > > they autofiltered a column upon which they got the #Name? error and then
| > | > > > > > even
| > | > > > > > when they unfilter it does not go back.
| > | > > > > >
| > | > > > > > I had every one on my team install the add ins for the toolpack etc.
| > | > > > > >
| > | > > > > >
| > | > > > >
| > | > > > >
| > | > >
| > | > > --
| > | > >
| > | > > Dave Peterson
| > | > >
| > |
| > | --
| > |
| > | Dave Peterson
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is NETWORKDAYS Supported in Excel to Web Page? 1
Counting DD:HH:MM NETWORKDAYS and Hours 4
Formula Workdays-Holidays-adjustments 4
Nested Ifs & NetworkDays Combined Functions 4
=NETWORKDAYS not working as expected and as it once did 2
Net workdays error 3
#NAME? Error 3
#NAME? 7

Top