View previous topic :: View next topic |
Author |
Message |
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Tue Sep 30, 2008 5:38 pm Post subject: Excel Add-In XYYY function broken in 2.2.1.4 |
|
|
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:
- 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.
- 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.
- 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 |
|
Back to top |
|
|
jsc
Joined: 02 Dec 2005 Posts: 222
|
Posted: Tue Sep 30, 2008 6:47 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
Ashi
Joined: 30 Dec 2007 Posts: 28
|
Posted: Mon Oct 06, 2008 5:05 pm Post subject: |
|
|
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) |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Mon Oct 06, 2008 8:13 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
Ashi
Joined: 30 Dec 2007 Posts: 28
|
Posted: Fri Oct 17, 2008 11:33 am Post subject: |
|
|
Finally got it to work! Don't know what I did differently. |
|
Back to top |
|
|
|