Loss of Some Functions in Excel 2003 with Vista

[DRA]

I just installed the Windows Vistas Service Pack 1. Now the yearfrac
function and FV functions don't work. Anytime they appear in a workbook, I
get "#Value!".

Before installing the service pack, I had this same problem twice, and it
got my functions back by uninstalling MS Office 2003 and reinstalling it. I
did the uninstall and re-install, but no luck this time.

Help

 

[Mike Middleton]

DRA or Don -

The errors might not be related to SP1. Some things to check:

YearFrac requires the Analysis ToolPak.

#VALUE! usually indicates the wrong type of argument for a function, so if
the arguments are references to other cells, check to see that the
appropriate values are being returned in those cells.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[DRA]

I added the Analysis ToolPak - VBA and things cleared up. I already had the
Analysis ToolPak.
--
Thanks,
Don

DRA or Don -

The errors might not be related to SP1. Some things to check:

YearFrac requires the Analysis ToolPak.

#VALUE! usually indicates the wrong type of argument for a function, so if
the arguments are references to other cells, check to see that the
appropriate values are being returned in those cells.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel