Excel 97 file size limit?

F

Frank

Hi, I use Excel 97(version created in 1996) on windows 98. I am not a
computer expert and I need some perspective on how large I could eventually
make a file before it reaches it's limit and will not function anymore. I
use one file and only one workspace in that file. I will keep adding data in
cells and formulas in some cells to calculate entered data. My total file
size is 10,500KB so far. I have a bunch of numeric data entered from cell A1
to DZ1320. Then I have a number of formulas in cells from A1325 to P1460.
My formulas are basicly simple, average "this row" and "total that column" -
no arrays or complicated stuff. My question: how much larger can I make this
file, twice as large, 3times, etc..? If I am getting close to maxing it out,
what software would you suggest I go to? Sorry I am behind the tech curve
but appreciate anyones help!
Frank :)
 
A

Amedee Van Gasse

Frank said:
Hi, I use Excel 97(version created in 1996) on windows 98. I am not
a computer expert and I need some perspective on how large I could
eventually make a file before it reaches it's limit and will not
function anymore. I use one file and only one workspace in that
file. I will keep adding data in cells and formulas in some cells to
calculate entered data. My total file size is 10,500KB so far. I
have a bunch of numeric data entered from cell A1 to DZ1320. Then I
have a number of formulas in cells from A1325 to P1460. My formulas
are basicly simple, average "this row" and "total that column" - no
arrays or complicated stuff. My question: how much larger can I make
this file, twice as large, 3times, etc..? If I am getting close to
maxing it out, what software would you suggest I go to? Sorry I am
behind the tech curve but appreciate anyones help! Frank :)
Click to expand...

I don't know about a built-in limitation, but you'll hit a performance
wall long before that!
Reorganising your file, using named ranges, array formulas,... might
help reducing the size. But that is advanced stuff...

Also try http://users.skynet.be/onderland/Excel.htm#Addins
"20 - Bestandscompressie".
It's in Dutch but that shouldn't be a problem for usage.
 
Top