DPlot

I have a 180x180 table of values in excel which I want DPlot to create a surface plot for. I've tried using the excel add-in call for a ZGrid and a ZScatterTable but both kick back the same VBA error. The error is in excel and the DPlot window stays empty.

Run-time error '9':

Subscript out of range

I've gotten the ZGrid call to work by cutting my table down to 100x100, but if I change any of the x or y axis values I get the same Run-time error.

I'm using excel 2007 in XP x64. DPlot version 2.2.7.7

I've tried searching the forum for the run-time error but I couldn't find anything. Any help with this problem would be appreciated.

I tried an example with a 180x180 grid just now, and it worked fine for me. Looking at the ZGrid code I don't see anything that is data-specific that would cause a problem, but I've been wrong before. At your convenience please send me your spreadsheet.

Thanks for your file - that was very helpful.

There's a goof in the ZGrid and ZScatterTable functions in the new Add-In that results in an unhelpful "Runtime Error 9" if either X or Y are not evenly-spaced. I'll be making a full update later tonight, but there's no reason for you to wait.

Exit Excel if it is running. Get http://www.dplot.com/excel/dplotlib.xla and save to %APPDATA%\Microsoft\AddIns, overwriting the existing copy.

I apologize for any inconvenience this problem caused.

Ryan: By the way mail sent to your reply-to address was rejected. I'm not sure if that's a goofy setup for your mail or a whitelist-thing. In any case, my reply to the second part of your mail was:

On your other problem, it sounds like you're running multiple accounts on
the same system - yes? If so you can get around this problem by copying
%APPDATA%\DPlot\dplot.ini to %ALLUSERSPROFILE%\DPlot