Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula is driving me crazy????? | Excel Worksheet Functions | |||
Sorry for reposting - but this is driving me crazy! | Excel Discussion (Misc queries) | |||
VLOOKUP driving me crazy | Excel Discussion (Misc queries) | |||
basic...but driving me crazy! | Excel Discussion (Misc queries) | |||
HELP!? Passwords are driving me crazy. | Excel Worksheet Functions |