Stan

Posts: n/a

NETWORKDAYS() not avaialbe after reopening

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed	Stan Brown	Excel Worksheet Functions	15	June 10th 05 04:33 PM
NETWORKDAYS function problem	Arvi Laanemets	Excel Worksheet Functions	5	April 19th 05 08:10 AM
networkdays	Liesel1	Excel Worksheet Functions	3	January 17th 05 06:49 PM
Networkdays shows as #NAME even though I have the toolpack instal.	mark	Excel Discussion (Misc queries)	1	December 1st 04 09:13 PM
MS Excel Function - Networkdays	Nilesh Inamdar	Excel Worksheet Functions	3	November 26th 04 07:10 PM

All times are GMT +1. The time now is 02:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us