Posted to microsoft.public.excel.worksheet.functions
|
|
Loss of Some Functions in Excel 2003 with Vista
I added the Analysis ToolPak - VBA and things cleared up. I already had the
Analysis ToolPak.
--
Thanks,
Don
"Mike Middleton" wrote:
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" wrote in message
...
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
--
Thanks,
Don
|