A #NAME error apears in cells when Excel does not recognise a function used in a cell formula. Most of the files in the repository use the XLC addin so that cell formulae can be displayed as mathematical equations. The XLC addin uses special non-standard Excel functions, so if it is not installed then #NAME errors will occur. XLC functions are called EQS(), OVD(), UND(), ODI() and UDI(). It is simply rectified by installing the XLC addin. It is also possible that documents require other Excel Addins but the addins are usually listed somewhere in the document.

XLC Ribbon version reading a file created in XLC Toolbar version:  if a calculation was created in the toolbar version of XLC and is subsequently loaded up by the ribbon version of XLC it will throw up #NAME? errors. To rectify just press the [CTRL+SHIFT+J] keys simultaneously.  

XLC Toolbar version reading a file created in XLC Ribbon version:  if a calculation was created in the ribbon version of XLC and is subsequently loaded up by the toolbar version of XLC you will be warned that the document is linked to other data sources. Select "Don't Update" and open the document. You will see some #NAME? errors where XLC functions are used. When you examine the formula you will see something like

'C:\Program Files (x86)\XLC\XLC.xlam'!OVD(...)

Simply use Excels Find and Replace functions to remove "'C:\Program Files (x86)\XLC\XLC.xlam'!" and replace with ""

We have 240 guests and 3 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.