Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What increased my file size from 2mb to 5mb in a week?
I didn't add any macros, just maybe30-40 extra rows of information. I
am filling up each cell with at least a paragraph of information though and am adding hyperlinks, is that what does it?. I have files that have a ton more information that this that are half the size so it must be something I'm doing differently with this current file. What are some of the things that really bulk up the size of an excel file that I can avoid? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What increased my file size from 2mb to 5mb in a week?
On Mar 25, 8:32 pm, Joe wrote:
I didn't add any macros, just maybe30-40 extra rows of information. I am filling up each cell with at least a paragraph of information though and am adding hyperlinks, is that what does it?. I have files that have a ton more information that this that are half the size so it must be something I'm doing differently with this current file. What are some of the things that really bulk up the size of an excel file that I can avoid? ahhh, I found it, I just cut out 5 formulas and that shaved 3mb off of the size. That seems weird that a formula would cause such a file size increase, is that normal? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What increased my file size from 2mb to 5mb in a week?
What formulae did you get rid of?
Pete On Mar 26, 12:35*am, Joe wrote: On Mar 25, 8:32 pm, Joe wrote: I didn't add any macros, just maybe30-40 extra rows of information. I am filling up each cell with at least a paragraph of information though and am adding hyperlinks, is that what does it?. I have files that have a ton more information that this that are half the size so it must be something I'm doing differently with this current file. What are some of the things that really bulk up the size of an excel file that I can avoid? ahhh, I found it, I just cut out 5 formulas and that shaved 3mb off of the size. That seems weird that a formula would cause such a file size increase, is that normal? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What increased my file size from 2mb to 5mb in a week?
I created 5 formulas to help sort some zip codes like this:
= -- ISNUMBER(MATCH(J971, {"10580";"10583";"10573";"06807";"06830";"06831";" 06832";"06836";"06878";"06901";"06902";"06903";"06 904";"06905";"06906";"06907";"06910";"06911";"0691 2";"06913";"06914";"06920";"06921";"06922";"06925" ;"06926";"06927";"06928"}, 0)) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What increased my file size from 2mb to 5mb in a week?
Rather than including the "hard values" that you wish to match as part of
your function, you may want to consider creating a "table" (list) of the values on a separate tab and use the following formula instead to check for a match: If(ISERROR(VLOOKUP(A1,Table,1,FALSE)),"",VLOOKUP(A 1,Table,1,FALSE)) where A1 is a cell on your data spreadsheet that you are trying to match and Table is the range of the values established on your Table tab. This formula will return blank ("") when no match can be found or the value in the Table when a match can be found. -- EarlyBirdie "Joe" wrote: On Mar 25, 8:32 pm, Joe wrote: I didn't add any macros, just maybe30-40 extra rows of information. I am filling up each cell with at least a paragraph of information though and am adding hyperlinks, is that what does it?. I have files that have a ton more information that this that are half the size so it must be something I'm doing differently with this current file. What are some of the things that really bulk up the size of an excel file that I can avoid? ahhh, I found it, I just cut out 5 formulas and that shaved 3mb off of the size. That seems weird that a formula would cause such a file size increase, is that normal? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
File size increased 7-fold! | Excel Discussion (Misc queries) | |||
Can actual size of CHECK BOX be increased? | Excel Worksheet Functions | |||
Height Needs To Be Increased In Row | Setting up and Configuration of Excel | |||
Excel file size increased | Excel Discussion (Misc queries) |