| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Loss of Some Functions in Excel 2003 with Vista
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Loss of Some Functions in Excel 2003 with Vista
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Partial Loss of Data between Excel 2003 Versions | Excel Discussion (Misc queries) | |||
| Excel 2003 on Windows Vista | Excel Discussion (Misc queries) | |||
| Excel 2003 Running in Vista | Excel Discussion (Misc queries) | |||
| upgrade to Excel 2003 - loss of text color on screen | Setting up and Configuration of Excel | |||
| Excel on Vista functions? | Excel Discussion (Misc queries) | |||
Linear Mode
