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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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