#Excel 2010 64 bit file size limit code

But there's nothing magic about an XLA file other than once set up it is automatically loaded when you start Excel. It is possible that I sent you an XLS file previously to help debug something. The Add-In has always been an XLA file, not XLS. Am I having a backwards compatibilty problem? Anyway, I hope this is the info you need. Just noticed that Dplot is in xla, and if I remember correctly 2007 is xls. I have feeling that I haven't set something up correctly in 2010. The Debug function on the error form highlights at the ReDim X(DataRowCount * NumCurves -1) in DplotData.XLA.

#Excel 2010 64 bit file size limit code

When I adjusted the array size, Dplot will now plot these large files from the import function, but when plotting an XYYY from the Excel add-in it still gives the error 7 code when plotting more than 3 columns. I added Dplot as an add-in and this when i started having this problem. I bought office 2010 and loaded it on my computer. I reloaded Dplot and got updates on my new computer(Windows 7 64 bit). Posted: Wed 8:33 pm Post subject: Error 7ĭavid, my computer crashed. If that doesn't help then you'll obviously be better off reading the CSV file directly into DPlot with Excel closed. You should still be able to do this on a 2Gb system. PS: With that same sheet open in Excel, Excel eats up 242Mb. With the example above, Task Manager shows DPlot eating up ~46Mb. It might get this badly wrong if the first N rows use many fewer characters per row than the remainder of the file, and so overestimate the required number of points.ĢGb should be plenty for what you're talking about, assuming you aren't running everything under the sun. number of data points is N and DPlot reads N rows but doesn't reach the end of the file, it estimates how many rows are in the file based on the file size and how many bytes were processed for those N rows. The reason for that is that if, for example, the max. When reading a CSV file directly into DPlot, if you know how many data rows are in the file then you should first double-click the 'Array size' area of the status bar and enter values large enough to accommodate your data. If there's any more information you can give me about what you're trying to do, what Add-In command you're using, etc., that might be helpful. When saved as a CSV file DPlot read the file, no problem. It took at least a minute, but it worked: in DPlot I get 4 curves with 500,000 points each. What version of Excel? 32-bit or 64-bit?įYI I just now tried a sheet with 5 columns of 500,000 points and the XYYY command. Is there a work-around, besides splitting the files?ĭefinitely not a DPlot limitation, though the Add-In may be fouling something up. Is this a limitation of Dplot, lack of RAM(2G installed), or an Excel limitation? csv files (above 500,000 rows) and when I try to plot more than three columns from either Dplot or Excel I'm prompted with a run time error 7 'Not enough Memory'. Posted: Tue 8:25 pm Post subject: Error 7 Profile Log in to check your private messages Log in