#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default NETWORKDAYS

I use NWD alot on my reports and EVERY now and then, it just fails
(formula and VBA versions)....What I do is close out all instances of
Excel, re-open, uncheck the addins, close Excel, re-open and check the
addins. Then NWD works again.

Does anyone have any idea why this happens??


Hans

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default NETWORKDAYS

<it just fails

How do you notice that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
|I use NWD alot on my reports and EVERY now and then, it just fails
| (formula and VBA versions)....What I do is close out all instances of
| Excel, re-open, uncheck the addins, close Excel, re-open and check the
| addins. Then NWD works again.
|
| Does anyone have any idea why this happens??
|
|
| Hans
|


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default NETWORKDAYS

Niek,

I just saw your post and funny thing...it failed again.. I get #Name?
error


Hans

Niek Otten wrote:
<it just fails

How do you notice that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
|I use NWD alot on my reports and EVERY now and then, it just fails
| (formula and VBA versions)....What I do is close out all instances of
| Excel, re-open, uncheck the addins, close Excel, re-open and check the
| addins. Then NWD works again.
|
| Does anyone have any idea why this happens??
|
|
| Hans
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Combining an If Statement with NETWORKDAYS function Shirley Munro Excel Discussion (Misc queries) 1 June 21st 06 12:42 PM
networkdays vs days360 Toothfaerie Excel Discussion (Misc queries) 1 May 31st 06 02:56 AM
NETWORKDAYS question Seymour Excel Worksheet Functions 5 November 8th 05 12:35 PM
NETWORKDAYS() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 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 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"