Formula driving me crazy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If you want to use the NETWORKDAYS function, you must install the
Analysis Tool Pack add-in.

Hope this helps.

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


--


Regards,


Peo Sjoblom
 
Networkdays function is required Analysis ToolPak Add-Ins

Tools > Add-Ins > select Analysis ToolPak > OK out
 
Hi

It sounds as though the Analysis Toolpak isn't loaded on the Laptop.
Tolls>Addins>Analysis Toolpak> check the box
 
If you're having problems with an Excel function, it's always worth looking
up that function in Excel help.
 
Still, he seems happy enough with the answer - though he's replying to
his own post <bg>

Pete
 
Back
Top