Install Analysis Tool Pak. From menu
ToolsAddInscheck 'Analysis ToolPak' and hit OK

If this post helps click Yes
---------------
Jacob Skaria


"dickie12" wrote:

Recently I had to restore Microsoft Office. When accessing a spreadsheet
created before I restored the yearfrac is not recognized. How do I reload
this frunction?
--
dickie12