[RESOLVED] Is size important

The bean counters here insist on making these huge excel sheets to count their beans. The small ones are about 3meg, but can go as high as 18meg. When they get to this size we get problems just getting them to load, let alone make any changes.

So my question is. Is there a maximum size to a spread sheet?

I've also heared that office 97 bloats the size compared with office 2000. Do any of you people know if this is true?

Thanks in advance

------------------
The Wisdom of Will Rogers: - Don’t squat with your spurs on.

I have a Access 97 database that is about 14 Meg big, and I dont have a problem loading that, and it is also over a network. I am running a PIII 450, 256MB Ram, and a 64MB video card. Check to see what kind of system your guys are running, and if they insist on creating their speadsheets that large, then they will require an upgrade. Also, try going thorugh the machine and cleaning out unneccesary crap that slows machine down. My 2 cents.

https://forums.windrivers.com/

------------------
Things to to when your bored at Wal-Mart...

Set all the alarm clocks to go off at ten minute intervals throughout the day.

I'm not sure about size of Excel 2000 vs 97 files, but Word 2000 vs 97 files are much compressed. I believe that Office 2000 files use some type of compression scheme...just try Zip'ing a Word 2000 file and you get very little reduction in size. I expect Excel 2000 is doing the same thing... http://forums.windrivers.com/cgi-bin...lies/cwm16.gif

------------------
Sometimes computer problems require extreme measures. Our hero, the Intrepid Spaceman Spiff, sets his blaster on "deep fat fry..." https://forums.windrivers.com/

Quote:

---

<font face="Verdana, Arial" size="2">Originally posted by Who Me:
The bean counters here insist on making these huge excel sheets to count their beans. The small ones are about 3meg, but can go as high as 18meg. When they get to this size we get problems just getting them to load, let alone make any changes.

So my question is. Is there a maximum size to a spread sheet?

I've also heared that office 97 bloats the size compared with office 2000. Do any of you people know if this is true?

Thanks in advance

</font>

---

I've used both, am using 2k now. 97 saves the frist file, when you make any changes it saves them and the frist, so it just keeps growing until you save it as, {save as} rename it and the file size will go back to a smaller size... 2k does just about the same thing only it saves it in a compressed form.. Office pro /95 kinda started this trend just not as much bloating...

Unlike a database all the information on a particular worksheet is loaded into memory at the time of opening. You should try to educate the "bean counters" to use multiple (more) worsheets to segment the work and try to increase the organization and lessen the load time and moke the spreadsheet less cumbersome to work with.

Just my 2c

------------------
Death is lighter than a feather - duty heavier than a mountian.

One of my customers, is running Win98SE and Office 2000 Premium, and has an estimating spreadsheet template that is 42MB, and it is running fine.
The estimating computers are PIII 700, with 256MB RAM

------------------
An obstacle is something you see when you take your eyes off your goal.

I work with Both Access '97 and '00 and do tell the truth I don't prefer one over the other. We '00 for some things and '97 for most other. Our biggest database is 100GB but we had a programmer custom build programs to play with it.(we also use a server called corvette. Its a Dell 6350) On our normal machines we open them up to about 300MB with 500P3 with 256RAM it never takes more than a minute.

Quote:

---

<font face="Verdana, Arial" size="2">Originally posted by cyberhh:
Unlike a database all the information on a particular worksheet is loaded into memory at the time of opening. You should try to educate the "bean counters" to use multiple (more) worsheets to segment the work and try to increase the organization and lessen the load time and moke the spreadsheet less cumbersome to work with.
</font>

---

Yeah, no kidding. Who on earth wants to work with a single massive worksheet? Learn to link, you bean counters...

Well, it can't be BAAAAAAAAAAHHHHHHHHHHHH, you have enough RAM, hmm, they are just bean-counters.

------------------
I don't suffer from insanity. I enjoy every minute of it.

Also you need video memory as well to cache anything graphic intersive, add more RAM.

------------------
Death is lighter than a feather - duty heavier than a mountian.