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!
|