I think I'd try turning the analysis toolpak addin off, then turn it on to see
if that helped.

If it didn't, I think I'd reinstall that addin (maybe even remove it first).

Stan Brown wrote:

This is a real head-scratcher in Excel 2003 under Win XP Pro SP2.

My formula is
=MIN(ProfWeeks,MAX(0,NETWORKDAYS(E7,TODAY())))
and it gives #NAME?. I clicked on the little ! icon and chose Show
Calculation Steps; it confirms that NETWORKDAYS is the problem.

Yes, ATP is checked in "Tools - Addins".

http://support.microsoft.com/default...b;en-us;291058 gives
advice, which I followed, to force a recalculate. That didn't help
either.

Help!

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"I feel a wave of morning sickness coming on, and I want to
be standing on your mother's grave when it hits."

--

Dave Peterson