#NAME? Error on Entire Worksheet

  • Thread starter Thread starter denisel
  • Start date Start date
D

denisel

I have an excel worksheet that I use for scheduling. One worksheet i
pretty much all formulas that look like,

=IF(BK193<>"",IF(K193<>"",IF(BK193<>"",WORKDAY(BK193,-K193,Holidays),""),""),"")

where WORKDAY and Holidays are defined on another worksheet within th
same workbook.

This morning I opened the workbook and every single cell with a formul
was outputting the #NAME? error.

Any ideas on how I can fix this or even where to begin looking? I hav
exhausted the excel help options.

Thanks,
Denis
 
WORKDAY is part of the Analysis Toolpak addin. Do you know if you had it
installed (I'm assuming you had to have had it) and whether it is now not?
Tools / Addins - See if it is there but just unchecked, and if so then tick it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
 
Back
Top