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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JPS" wrote in message
...
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?

=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.



"Niek Otten" wrote in message
...
What is your formula? And what are the values of the arguments?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JPS" wrote in message
...
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?

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)

On Fri, 13 Mar 2009 16:51:59 -0400, "JPS" wrote:

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?