Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reduce file size in Excel | Excel Discussion (Misc queries) | |||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB) | Setting up and Configuration of Excel | |||
How can I reduce the size of my Excel file without zipping it? | Excel Discussion (Misc queries) | |||
How do I reduce the file size of an Excel document? | Excel Discussion (Misc queries) | |||
how to reduce file size of excel workbooks | Excel Discussion (Misc queries) |