#NAME error

[Guest]

Hi,
I've been using the same spreadsheet for over two years and today get a
#NAME error in my cells that contain NETWORKDAYS.
When I check off Analysis toolpak and morefunc, close and then check them
back on, the sheet calculates properly.
So I guess something has happened and Excel is not remembering my settings.
Any advise on this one?

TIA
GerryK

 

[Guest]

This error is returned if Excel doesn't recognize the function you are trying
to use. As you describe in your post below, when you install the Analysis
Toolpak, this problem is resolved.

Dave