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.

"K" wrote in message
...
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