I've about reached my level of incompetence with the Excel Add-In with this version of Excel. It almost works, but there are a couple of gotchas that I've been scratching my head over for a while and have reached a dead end.
1) There's a single function that is called by all Add-In functions that adds a hidden note to the produced plot, describing the source reference, e.g. "Source: [examples.xls]ZGrid!B6:AG37". Works swell in Excel 2010 32-bit and all previous versions of Excel, but for some reason I can't fathom this crashes Excel 2010 64-bit.
2) The precursor to the Add-In, dplotlib.xls, works fine with Excel 2010 64-bit (after commenting out the function mentioned in #1). But if I try to save as either a new .xlam Add-In or the old .xla format, Add-In functions work (sometimes) once, but never twice. The second time (and sometimes the first) has always resulted in a crash of Excel.
If you feel like you're in the know about 64-bit Excel, or even if you just want to take this for a spin, please contact me at support@dplot.com. You'll be able to fiddle around with the VBA code as much as you'd like. Any pointers would of course be most welcome.
Paging any Excel 2010 64-bit gurus
Moderator: DPlotAdmin
- DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
Paging any Excel 2010 64-bit gurus
Visualize Your Data
support@dplot.com
support@dplot.com
- DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
I believe I've beaten this one into submission now, and a .XLAM version of the Add-In will now work with Excel 2010 64-bit. To load the updated Add-In:
Your comments and of course any problems you run in to are of course welcome.
- If you have previously installed an older Add-In then:
- Start Excel.
- Select File>Options.
- Select Add-Ins in the left pane
- Ensure "Excel add-ins" is selected in the "Manage" list at the bottom of that dialog, and click Go.
- Uncheck "DPlot interface" if it is checked, then click OK.
- Exit Excel.
- Using Explorer, navigate to %appdata%\Microsoft\Addins.
- Delete dplotlib.xla.
- Download http://www.dplot.com/excel/dplotlib.xlam, saving the file to %appdata%\Microsoft\Addins.
- Start Excel
- Select File>Options
- Select Add-Ins in the left pane
- Ensure "Excel add-ins" is selected in the "Manage" list at the bottom of that dialog, and click Go.
- Check "DPlot interface", then click OK.
Your comments and of course any problems you run in to are of course welcome.
Visualize Your Data
support@dplot.com
support@dplot.com
- DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
Using Explorer, look in %appdata%\Microsoft\Addins. Is there a dplotlib.xla or dplotlib.xlam there?
If you don't have that folder, create it and download dplotlib.xlam from the link provided, saving to that folder.
If none of that helps, use File>Options, select Add-Ins in the left pane, click "Go" next to "Excel add-ins". Is "DPlot interface" there and is it checked?
If you don't have that folder, create it and download dplotlib.xlam from the link provided, saving to that folder.
If none of that helps, use File>Options, select Add-Ins in the left pane, click "Go" next to "Excel add-ins". Is "DPlot interface" there and is it checked?
Visualize Your Data
support@dplot.com
support@dplot.com