Excel 2007

[agarwaldvk]

Hi Everybody

I know it might be a trifle early but has anyone used Excel 2007 beta version?

I am trying to develop a large Excel based application - in fact I already have a smaller version of it running on Excel 2003 operating on Windows XP. The newer version of my application will be a whole lot bigger in file size but not necessarily in number of rows. The number of rows per worksheet is around 5000 only. However with Excel 2003 on Windows XP, I seem to not be able to exceed 80 MB file size. With the new application, I am anticipating that my file size will will in th realms of around 200 MB with about 60% of content in pure values (storage of primary data in various worksheets for nmber crunching) and the remaining 40% or less in formulas.

Is anyone aware if Excel 2007 on Windows XP will be OK with this size of spreadsheet.


Any pointers please?


Best regards


Deepak Agarwal

 

[SydneyGeek]

Hi Deepak, welcome to the Board!

I'd be worried about the stability of an 80MB workbook. Any chance you could store the raw data in Access, and only pull in what you need for computation?

Check out this site for detail on memory limits to 2003, and this page for 2007.

Denis

 

[agarwaldvk]

Dear SydneyGeek

Yeah, I have had a lookat both of these sites before. From there its quite obvious that with Excel 2003, spreadsheet of sizes of a couple of hundred megs or even bigger shouldn't be a hassle but I can't understand why in my scenario I am getting limited to around 80 MB file size.

About file stability, I am not so sure if that is what is causing my problem. I haven't even bothered to look at the swap file and RAM etc etc (I anyway have 1 GB RAM on my PC) but anyway.

Considering the option of storing some of these values outside of this workbook either in a separate workbook or in Access, I don't think serves my purpose because of the 15000 line VBA code that reads these values from within the workbook. If this is what I need to be looking at then I might as well start from scratch wih an entirely different philosophy.

Thanks anyway, mate!

See if you can think of any of the other avenues that I can explore to work with large workbooks of the order of 200 MB or thereabouts.


Best regards


Deepak Agarwal