Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula only working for 1 user on 1 computer
I created a network days formula that excludes holidays,
=NETWORKDAYS(E12,AU12,$A$1:$A$9). Saved on a spreadsheet in a shared file. Works on my computer when I am logged in. Doesn't work (get the 'name' error): -on other computers when I am logged in -on other computer when someone else is logged in -on my computer when someone else is logged in All computers have same 2003 version of Excel. Any ideas?? I'm stumped! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula only working for 1 user on 1 computer
Each user has to have loaded the Analysis Toolpak addin:
Tools|Addins Depending on how excel was installed, each user may need the installation CD. shebe wrote: I created a network days formula that excludes holidays, =NETWORKDAYS(E12,AU12,$A$1:$A$9). Saved on a spreadsheet in a shared file. Works on my computer when I am logged in. Doesn't work (get the 'name' error): -on other computers when I am logged in -on other computer when someone else is logged in -on my computer when someone else is logged in All computers have same 2003 version of Excel. Any ideas?? I'm stumped! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula only working for 1 user on 1 computer
Here's an alternative that will work on all of the machines:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(E12&":"&AU12)),2)<6),--(ISNA(MATCH(ROW(INDIRECT(E12&":"&AU12)),$A$1:$A$9, 0)))) -- Biff Microsoft Excel MVP "shebe" wrote in message ... I created a network days formula that excludes holidays, =NETWORKDAYS(E12,AU12,$A$1:$A$9). Saved on a spreadsheet in a shared file. Works on my computer when I am logged in. Doesn't work (get the 'name' error): -on other computers when I am logged in -on other computer when someone else is logged in -on my computer when someone else is logged in All computers have same 2003 version of Excel. Any ideas?? I'm stumped! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula only working for 1 user on 1 computer
Thank you, this fixed it.
"Dave Peterson" wrote: Each user has to have loaded the Analysis Toolpak addin: Tools|Addins Depending on how excel was installed, each user may need the installation CD. shebe wrote: I created a network days formula that excludes holidays, =NETWORKDAYS(E12,AU12,$A$1:$A$9). Saved on a spreadsheet in a shared file. Works on my computer when I am logged in. Doesn't work (get the 'name' error): -on other computers when I am logged in -on other computer when someone else is logged in -on my computer when someone else is logged in All computers have same 2003 version of Excel. Any ideas?? I'm stumped! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap Text is not working correctly on one persons computer | Excel Discussion (Misc queries) | |||
Keyboard shortcut not working when I copy macro to another computer | New Users to Excel | |||
User defined buttons in Toolbars,transfer to another computer | Excel Discussion (Misc queries) | |||
DB not working on other computer | New Users to Excel | |||
Maskerr function not working on my new computer - help? | Excel Worksheet Functions |