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?

Are you using the same computer?

--


Regards,


Peo Sjoblom

"Windy" wrote in message
...
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?

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

"Windy" wrote:

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?

....was NOT loaded...

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

Mike H wrote:

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

"Windy" wrote:

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?

--

Dave Peterson