Largest filesize for Excel 3

[nfpk]

Hello!
Does anyone know the limit for Excel.
I mean, is there a maximum filesize??
How big can an Excelfile be?

 

[carrr]

That depends on your system capabilities, coupled with the fact that Excel supports 256 columns and 65536 rows.

 

[WildHare]

Carrr wrote:
That depends on your system capabilities, coupled with the fact that Excel supports 256 columns and 65536 rows.

..per sheet. The number of sheets in a workbook is limited only by available system memory. Excel (at least through version 2002) must be able to load the entire workbook into RAM. So that's your real limit, and obviously may vary from PC to PC.

Jim

If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[xlbo]

But generally, anything over 25mb will run like a dog. The real issue is the number of dependancies in the workbook. A dependancy is a cell, that if changed, will result in a formula being re-calculated. Excel can track up to 65536 dependancies but once it goes past this limit, it has to recalc EVERYTHING whenever a change is made anywhere. This can result in the workbook being unusable, even though you could technically enter more data and increase the file size.

Fr'instance, I have 1 workbook that is 54mb in size. It takes a little while to open but once open, becasue it has few formulae, it is easy to work with. I have another workbook that is a measly 2.3mb in size but has so many formulae that it was nearly impossible to work with and I had to switch to manual calculation and write all sorts of code to enter formulae at certain points etc. So you see, it ain't the size that matters....it's what you do with it ;-)

For the record, my largest workbook is 74mb and it runs horribly slowly but it DOES work.....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[KenWright]

Excel has it's own internal memory limits that vary from version to version, irrespective of any RAM considerations. These are also usually more restrictive that any RAM limits you may have. A workbooks size when closed can be very deceiving when closed, as depending on the contents a small file may well run far slower than a big file. See the following link for a good overview:-

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

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

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[WildHare]

Ken - good link..have a star!..



If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[nfpk]

Thanks for that link, Ken

I have one more question, I don´t know if it has with memory to do.

Bur I have a friend who has this problem:
When she starts working with a special Excel file, the program stop working and she has to restart the computer. When I open the file there is no problem.
How can this happen?

 

[KenWright]

Are you both working with the same Version of Excel?? What do you mean by Special?? Do you have anything else open when doing so?? How big is the file?? What is in the File?? Could be a number of things.

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

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------