#NAME?

W

Windy

I have a spreadsheet which has the formula =NETWORKDAYS(B2,D2)-1 and now when
I try to fill information into the row the column with the formula (which
displayed -1 until this point) now fills in with #NAME? and if I move my
cusor to the above rows that had been correct, they too will change from a
numerical value to #NAME?. If I open a new workbook and try this formula I
now get #NAME? as well as on several different workstations that I have tried
it on.
What can I do to correct this situation before I fall too far behind on my
work?
 
M

Mike H

Hi,

You would get the #NAME? error if the analysis toolpak was loaded so try this

Tools|Addins

Check 'Analysis toolpak' if it isn't already checked.

Mike
 
D

Dave Peterson

....was NOT loaded...

(a short, but important word in that sentence <bg>.)
 
Top