Maxium size Excel file

[DeGeus]

When I make an Excel file and it exeeds the size of 100Mb its impossible to open it the next time. Does anybody know this problem and has anybody a way around. (Making the file smaller is no option)
Used excel version: Excel 2000
RAM memory of the PC: 512Mb

Leendert de Geus

http://WWW.CEC-CES.nl

 

[xlbo]

100mb excel file = time to switch to a database

Sorry but I don't build anything bigger than 25meg due to instability - excel just isn't built to handle that size of data.



Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[GrayShades]

This sounds like two problems - poor design and little attention to speed/size requirements. Check out the following site, and consider buying FastExcel (I have no part in the product, just a very satisfied customer).

http://www.decisionmodels.com/index.htm

The largest file I have ever seen is 29 MB, and it was not very efficiently designed. With redesign, it came down several MB, and its speed was dramatically improved.

Software: XL2002 on Win2K
Humanware: Older than dirt

 

[macropod]

Hi DeGeus,

I've regularly used Excel workbooks of ~60Mb and, apart from both opening and running slowly, even on fast PCs with lots of memory, I have found that networked PCs seem to lack the resources to open them.

And no, databases were not a viable alternative, due to the nature of the work being done - the workbooks concerned held minimal data and formatting, but held 1.4m formulae that proceesed a matrix of up to 250*400 elements.

Apart from the aforementioned problem with networked PCs, stability hasn't been a problem. If you're trying to run yours on a networked PC, try running it on a standalone PC instead - you may get better results.

Cheers

 

[KenWright]

Excel 2000 and Workbooks>100MB do not mix, irrespective of hardware. Excel has it's own internal memory limits that will get applied when you try and open a workbook.

Take a look at Charles Williams' site on this very topic:-

http://www.decisionmodels.com/memlimitsc.htm

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------