How do I reduce the file size in excel 2003
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. |
How do I reduce the file size in excel 2003
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" <<<<<<<<<<< "Anupam Arya" wrote: 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. |
How do I reduce the file size in excel 2003
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. Anupam Arya wrote: 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. -- Dave Peterson |
How do I reduce the file size in excel 2003
500MB!!!
Wow! What are the specs of your computer? Maybe you meant 50MB? Gord Dibben MS Excel MVP On Wed, 28 Oct 2009 02:11:01 -0700, BSc Chem Eng Rick wrote: 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" <<<<<<<<<<< "Anupam Arya" wrote: 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. |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com