BlueMonkey
MIS
Hi
I've created a spreadsheet which consists of 16 sheets of near identical information (one sheet per member of staff), and three analysis sheets. I'm now trying to insert the final of the analysis sheets, but when I do, the file size jumps up by 50% (from 4.3 mb to 6.6mb), and Excel starts to run really slow. The question in short is how does Excel manage file sizes and memory? I might be very wrong on this, but it appears to me that Excel only allocates 1mb RAM for each sheet/file (obtained by using =INFO) - is tis correct, and can it be increased.
Some pointers
* The final sheet is initially a copy of an existing sheet
* PC is a reasonably new laptop (approx 8 months) with 128mb RAM, 600mb Virtual RAM. I've closed everything else down to maximise resources.
* Excel & Windows 2000
* The staff sheets all refer to a "master" sheet, so lots of formulae (albeit very short and simple). No external files are linked.
* Have tried adding the final sheet in a number of ways, without success (eg copying the entire sheet, copying and pasting the relevant section).
* The sheets are all generally 550 rows, by 30 columns, so with 16 sheets I accept this will be a large file, but it's the final jump in size, and the sluggish performance that surprised me.
* All macros are held in a seperate "macro library" file
Thanks in advance.
BM Blue Monkey
I've created a spreadsheet which consists of 16 sheets of near identical information (one sheet per member of staff), and three analysis sheets. I'm now trying to insert the final of the analysis sheets, but when I do, the file size jumps up by 50% (from 4.3 mb to 6.6mb), and Excel starts to run really slow. The question in short is how does Excel manage file sizes and memory? I might be very wrong on this, but it appears to me that Excel only allocates 1mb RAM for each sheet/file (obtained by using =INFO) - is tis correct, and can it be increased.
Some pointers
* The final sheet is initially a copy of an existing sheet
* PC is a reasonably new laptop (approx 8 months) with 128mb RAM, 600mb Virtual RAM. I've closed everything else down to maximise resources.
* Excel & Windows 2000
* The staff sheets all refer to a "master" sheet, so lots of formulae (albeit very short and simple). No external files are linked.
* Have tried adding the final sheet in a number of ways, without success (eg copying the entire sheet, copying and pasting the relevant section).
* The sheets are all generally 550 rows, by 30 columns, so with 16 sheets I accept this will be a large file, but it's the final jump in size, and the sluggish performance that surprised me.
* All macros are held in a seperate "macro library" file
Thanks in advance.
BM Blue Monkey