Every time I open the workbook with NETWORKDAYS function I get #NAME? error.

The only workaround is this:

Uncheck Tools - Add Ins - Analysis Toolpak
Check Tools - Add Ins - Analysis Toolpak
Replace all formulas with NETWORKDAYS

Why does it happen?

Thanks,

-Stan

On Thu, 16 Jun 2005 14:55:52 -0400, "Stan" wrote:

Every time I open the workbook with NETWORKDAYS function I get #NAME? error.

The only workaround is this:

Uncheck Tools - Add Ins - Analysis Toolpak
Check Tools - Add Ins - Analysis Toolpak
Replace all formulas with NETWORKDAYS

There's something in the Microsoft Knowledge Base. If you force a
recalculate of all cells and then save, that might do it.

Look in my thread about NETWORKDAYS for the URL.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Modern cyberspace is a deadly festering swamp, teeming with
dangerous programs such as "viruses," "worms," "Trojan horses,"
and "licensed Microsoft software" that can take over your
computer and render it useless. --Dave Barry

On Sat, 18 Jun 2005 20:42:46 -0400, Stan Brown
wrote:

On Thu, 16 Jun 2005 14:55:52 -0400, "Stan" wrote:

Every time I open the workbook with NETWORKDAYS function I get #NAME? error.

The only workaround is this:

Uncheck Tools - Add Ins - Analysis Toolpak
Check Tools - Add Ins - Analysis Toolpak
Replace all formulas with NETWORKDAYS

There's something in the Microsoft Knowledge Base. If you force a
recalculate of all cells and then save, that might do it.

Look in my thread about NETWORKDAYS for the URL.

Specifically, it's message-id
and the URL at Microsoft
is http://support.microsoft.com/default...b;en-us;291058


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Modern cyberspace is a deadly festering swamp, teeming with
dangerous programs such as "viruses," "worms," "Trojan horses,"
and "licensed Microsoft software" that can take over your
computer and render it useless. --Dave Barry