How do I reduce the file size in excel 2003

[Anupam Arya]

My file szie is 1.3 MB. Up to what size is Ok to allow it to grow. Also I
want to know what are the ways to reduce the size. my file has lot of
database functions.

 

[BSc Chem Eng Rick]

I AA,

If your hard drive is formated FAT32 then the max file size is approx. 2GB,
if your drive is NTFS then file size is unlimited. I suggest that you don't
let the file get bigger than 500MB though, it starts becoming really arduos
to handle.

To reduce file size, most obvious is to elliminate all unecessary formating
(Italic, bold, borders, cell fill etc.). Also experiment with fonts, you will
notice that different fonts produce different file sizes (but this is only
really important when you have very large databases).

If this helps, please click "Yes"
<><><><><><><><><><><>

 

[Dave Peterson]

We used xl2k at work.

When the filesize hit about 20MB, I noticed a slowdown.

These workbooks were mostly data (few formulas), but when I'd add =vlookup()'s
formulas to 50k rows that used a table of 50k rows, it became very slow.

But there were times I had to use 40MB files and I could still do what I needed
to do--things (calculation) just too way too long for me.

 

[Gord Dibben]

500MB!!!

Wow! What are the specs of your computer?

Maybe you meant 50MB?


Gord Dibben MS Excel MVP