Thread: #NAME error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GerryK GerryK is offline
external usenet poster
 
Posts: 6
Default #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