Custom Functions Return #NAME?
Previous  Top  Next


When Excel returns #NAME? for a CDXZipStream function instead of a value this means that the program is not correctly installed on your system. Typically this means that the add-in used for the custom functions is not registered correctly. To address this perform the following steps.

Latest CDXZipStream 32/64 Bit Version Instructions

1. Make sure that all instances of Excel are closed on your system. To confirm this start the Windows "Task Manager" by pressing CTL-ALT-DEL and then clicking on this option. Select the processes tab and then sort by clicking on the "Image Name" header. Make sure there are no occurrences of Excel.exe. If there are right click on Excel.exe and then select "End Process".

2. Restart Excel and then check File-Options-Addins. You need to see two active addins CDX_ZipStream and CDX_ZipStream.UDF as shown below:

clip0483

CDX_ZipStream provides the user interface and CDX_ZipStream.UDF calculates the custom functions. Check to see if CDX_ZipStream.UDF is disabled or inactive. If so, enable it using the "Manage" function in the Addins dialog.

3. If this does not work from the Windows control panel Program section uninstall CDXZipStream. Then start Excel to be sure that it is removed and close Excel.

4. Download and then run the latest copy of the CDXZipStream installation file which can be found here.

Run the install normally. Do not use the "Run As Administrator" option.


CDXZipStream Classic 32 Bit Version Instructions

1. Make sure that all instances of Excel are closed on your system. To confirm this start the Windows "Task Manager" by pressing CTL-ALT-DEL and then clicking on this option. Select the processes tab and then sort by clicking on the "Image Name" header. Make sure there are no occurrences of Excel.exe. If there are right click on Excel.exe and then select "End Process".

2. Download and then run the latest copy of the CDXZipStream setup file which can be found here
.

3. When the install starts, click on "Run" and when prompted press "Next". Then select the "Repair Option" and press Next. On the following screen click "Install" to set up the program. If you are unable to perform a repair, uninstall the CDXZipStream program using Window's "Add/Remove Programs" and then reinstall it.

4. If the above steps do not correct the problem check that the CDXZipStream Add-ins are enabled on your system.

In Excel 2003 select the Excel Menu item "Help" and then click on "About Microsoft Excel". In the lower right hand corner of the screen that appears press "Disabled Items". If any add-ins beginning with CDXZipStream appear, click on them to re-enable. Then restart Excel.

In Excel 2007 click the Microsoft Office Button (the big circle in the upper left hand corner), click Excel Options, and then click Add-Ins. Check the "Inactive Application Add-ins" or "Disabled Application Add-ins" for add-ins that start with CDXZipStream. If any appear, use the "Manage" function at the bottom of the screen. Select the type "Com Add-ins" and then make sure that add-ins with CDXZipStream are checked. Then restart Excel.

In Excel 2010/2013/2016 use File-Options and then click Add-Ins. Check the "Inactive Application Add-ins" or "Disabled Application Add-ins" for add-ins that start with CDXZipStream. If any appear, use the "Manage" function at the bottom of the screen. Select the type "Disabled Application Add-ins" and then press the "Go" button. Enable any addins that begin with CDXZipStream. If no CDXZipStream add-ins are disabled use the "Manage" function and select the type "Com Add-ins" and then press the "Go" button. In the screen that appears make sure that add-ins with CDXZipStream are checked and press "OK".

5. If the above steps do not correct the problem check that the add-in CDXZipStreamCF.Connect is enabled on your system. In Excel 2003 use the Tools-Addins menu and make sure that CDXZipStreamCF.Connect is checked. If you don't see it you can use Automation button to select it from the list that appears.

In Excel 2007 click the Microsoft Office Button (the big circle in the upper left hand corner), click Excel Options, and then click Add-Ins. Use the "Manage" function at the bottom of the screen. Select the type "Excel Add-ins" and then make sure that the add-in CDXZipStreamCF.Connect is checked. If you don't see it you can use Automation button to select it from the list that appears.

In Excel 2010/2013/2016 use File-Options and then click Add-Ins. Use the "Manage" function at the bottom of the screen and select the type "Excel Add-ins" and then press the "Go" button. In the screen that appears make sure that add-ins with CDXZipStreamCF are checked and press "OK". If you don't see it you can use Automation button to select it from the list that appears.

6. If an error occurs when enabling add-ins you will need to run a repair of Microsoft Office. In Excel 2003 choose the Excel menu item "Help" and then run "Detect and Repair". In Excel 2007/2010 use Start \ All Programs \ Microsoft Office \ Microsoft Office Tools \ Microsoft Office Diagnostics.