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
| >
| >
| >
