Excel 2003 - 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

 

[DRA]

Wrong place. Sorry.

 

[Nick Hodge]

Go to Tools>Add-Ins... and re-apply the Analysis toolpak add-in

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk