Excel Add-In XYYY function broken in 2.2.1.4
Posted: Tue Sep 30, 2008 5:38 pm
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.
- 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.
