Formula driving me crazy
 

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

If you want to use the NETWORKDAYS function, you must install the
Analysis Tool Pack add-in.

Hope this helps.

Pete

On Oct 3, 9:53 pm, RocketMan
wrote:
For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

Make sure you install ATP (Analysis ToolPak) on your laptop, keep the cd/dvd
handy and click
toolsadd-ins and check Analysis ToolPak


--


Regards,


Peo Sjoblom


"RocketMan" wrote in message
...
For the past two years I have been running metrics on a share drive with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula.
Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

Networkdays function is required Analysis ToolPak Add-Ins

Tools Add-Ins select Analysis ToolPak OK out


"RocketMan" wrote:

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

Hi

It sounds as though the Analysis Toolpak isn't loaded on the Laptop.
TollsAddinsAnalysis Toolpak check the box

--
Regards
Roger Govier



"RocketMan" wrote in message
...
For the past two years I have been running metrics on a share drive with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula.
Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

If you're having problems with an Excel function, it's always worth looking
up that function in Excel help.
--
David Biddulph

"RocketMan" wrote in message
...
For the past two years I have been running metrics on a share drive with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula.
Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

OUTSTANDING!! Why didn't I think of that.

"RocketMan" wrote:

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

OUTSTANDING!! Why didn't I think of that.

"RocketMan" wrote:

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

OUTSTANDING!! Why didn't I think of that.

"RocketMan" wrote:

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

Formula driving me crazy
 

The fact that he received the #NAME error is a bit of a give-away !!

Pete

On Oct 3, 11:48 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
If you're having problems with an Excel function, it's always worth looking
up that function in Excel help.
--
David Biddulph

"RocketMan" wrote in message

...



For the past two years I have been running metrics on a share drive with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula.
Any
body got and ideas for this frustrated analyst?- Hide quoted text -

- Show quoted text -

Formula driving me crazy
 

Exactly, and if he'd looked it up in Help he would have found the answer.
--
David Biddulph

"Pete_UK" wrote in message
ps.com...
The fact that he received the #NAME error is a bit of a give-away !!

Pete

On Oct 3, 11:48 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
If you're having problems with an Excel function, it's always worth
looking
up that function in Excel help.
--
David Biddulph

"RocketMan" wrote in message

...



For the past two years I have been running metrics on a share drive
with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old
desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this
formula.
Any
body got and ideas for this frustrated analyst?- Hide quoted text -

- Show quoted text -

Formula driving me crazy
 

Still, he seems happy enough with the answer - though he's replying to
his own post <bg

Pete

On Oct 4, 12:16 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Exactly, and if he'd looked it up in Help he would have found the answer.
--
David Biddulph

"Pete_UK" wrote in message

ps.com...



The fact that he received the #NAME error is a bit of a give-away !!

Pete

On Oct 3, 11:48 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
If you're having problems with an Excel function, it's always worth
looking
up that function in Excel help.
--
David Biddulph

"RocketMan" wrote in message

...

For the past two years I have been running metrics on a share drive
with
the
same simple formula to add up the number of days between two dates and
take
out weekends =networkdays(2a,2b) and it works. Recently I got a
replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old
desktop
back in and it works fine, plug the laptop in and error. It's the same
files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this
formula.
Any
body got and ideas for this frustrated analyst?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -