| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME error
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#NAME error
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 -- Brevity is the soul of wit. "GerryK" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Hybrid Mode
