#NAME error with Workday function

  • Thread starter Thread starter JPS
  • Start date Start date
J

JPS

I'm using Excel 2003, the analysis toolpack is installed, and I calculated
the workbook, but the error persists. It is only happening on one computer.
Any ideas?
 
What is your formula? And what are the values of the arguments?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
 
=IF(Q2="","",WORKDAY(Q2,R2))

Q2 = Date R2 = Integer

It works fine on all computers in the office except one. It was previously
working on the computer that does not work.
 
The first thing I would do is unload the ATP, close Excel, open Excel,
and reload the ATP. If this doesn't do it, close Excel. Go to the
Windows Start Menu and enter

"C:\Program Files\Microsoft Office\Office11\Excel.exe" /unregserver

The quotes are required. Your actual path to Excel.exe may be
different. Then, do this again but change "/unregserver" to
"/regserver".

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top