What increased my file size from 2mb to 5mb in a week?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 26 Mar 2008 01:32 GMT

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?

Reply to this Message

Joe - 26 Mar 2008 01:35 GMT

> 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
[quoted text clipped - 3 lines]
> 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 to this Message

Pete_UK - 26 Mar 2008 02:11 GMT

What formulae did you get rid of?

Pete

> > 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
[quoted text clipped - 7 lines]
> the size. That seems weird that a formula would cause such a file size
> increase, is that normal?

Reply to this Message

Joe - 26 Mar 2008 02:53 GMT

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";"06904";"06905";"06906";"06907";"06910";"06911";"06912";"06913";"06914";"06920";"06921";"06922";"06925";"06926";"06927";"06928"},
0))

Reply to this Message

EarlyBirdie - 26 Mar 2008 16:07 GMT

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(A1,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.

Signature

EarlyBirdie

Reply to this Message