Excel Add-In XYYY function broken in 2.2.1.4

Found a bug? Tell us about it here

Moderator: DPlotAdmin

Post Reply
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Excel Add-In XYYY function broken in 2.2.1.4

Post by DPlotAdmin »

The "fix" in the XYYY command to take account of a varying number of rows introduced a bug that often leads to one of two Excel error messages (error codes 9 or 13), and you won't get a plot. To get a fixed Add-In:
  1. Start Excel.
    • In Excel 2003 and earlier versions, select Tools>AddIns and uncheck the "DPlot Interface" box.
    • In Excel 2007, click the Office button in the upper left corner. Click the "Excel Options" button. In the left pane click Add-Ins. At the bottom of the screen select "Excel Add-Ins" in the Manage box and click Go. Uncheck the "DPlot Interface" box.
    Click OK and exit Excel.
  2. Download the updated Add-In and save to %APPDATA%\Microsoft\Addins, overwriting the old version. If your browser doesn't accept %APPDATA% as a valid destination, on Windows 2000 and XP US English editions that is a shortcut to c:\Documents and Settings\<username>\Application Data. On Windows Vista it will generally point to c:\Users\<username>\AppData\Roaming.
  3. Restart Excel and perform the inverse of step 1: bring up the Add-Ins dialog, check the "DPlot Interface" box, and click OK.
Sorry for the trouble :?
Visualize Your Data
support@dplot.com
jsc
Posts: 222
Joined: Fri Dec 02, 2005 8:56 am

Post by jsc »

Ran into error 9 this morning and wondered what was going on... (2.2.1.5, XPPro SP2, Excel 2003)

Worked great. Thanks for quick fix.

Jon
Ashi
Posts: 28
Joined: Sun Dec 30, 2007 11:49 pm

Post by Ashi »

I tried doing that fix, putting the file around various directories of those you've mentioned, doesn't seem to have fixed the error.

I did the unchecking the add-in, exiting excel, then restarting excel and checking the add-in again. Didn't work for me.

Will the next update of dplot automatically fix this? I don't mind just bearing it that long!

(using vista with excel 2003)
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

The next release of DPlot will include the same fix mentioned in this thread, but if that's not working for you then something is amiss. Excel is a little strange about giving up old Add-Ins; that was the main reason for the instructions about disabling the old Add-In before copying the new one. If Excel was running at the time you copied that file to your hard disk then there's no way it will work correctly. If you check the date of %APPDATA%\Microsoft\Addins\dplotlib.xla and it is older than 9/30/2008, then something went wrong. Another problem might be that you have multiple copies of the AddIn. If you look at Tools>Addins and see more than one "DPlot Interface" then you have more than one copy and will need to search your hard disk for dplotlib.xla, deleting all of 'em and repeating the previous instructions.

And if you aren't using the XYYY command then we're talking about completely different things - in that case please let me know what AddIn command you're using and what error message you're getting.
Visualize Your Data
support@dplot.com
Ashi
Posts: 28
Joined: Sun Dec 30, 2007 11:49 pm

Post by Ashi »

Finally got it to work! Don't know what I did differently.
Post Reply