Home arrow Support arrow FAQs arrow Repository Downloads have #NAME errors
Repository Downloads have #NAME errors
Wednesday, 12 December 2007

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 ""

 

Comments  

 
#3 denniskirk 2013-12-18 08:10
John,
Yes all are 2007 or later so I will upgrade any PCs that currently run XLC Toolbar.
Thanks for the prompt response and the great product. We would not have been able to complete these quite complex calculations without it because validation would have been way too hard without the formulas.
Dennis
 
 
#2 JohnDoyle 2013-12-18 08:04
Providing all versions of Excel are Excel 2007 or later I suggest you install the ribbon version on all machines in the office. Uninstalling the toolbar version is easy got to the windows start button>Programs>XLC>uninstall XLC then install the ribbon version.
 
 
#1 denniskirk 2013-12-18 06:34
This is the same manual method I found for myself which is a very inelegant solution?

What do I do to change my current install from Toolbar to Ribbon? This would be a better outcome.
 

Please sign in or register to add a comment.

We have 9 guests and 35 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative