View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emilija emilija is offline
external usenet poster
 
Posts: 12
Default Connection between size and complexity

One general question, I have an excel file, now is about 13 MB, the whole
file is with formulas, nested formulas, using, IF, ISNA, ISDIV etc, ... than
SUMPRODUCT, mainly, SUMIF, VLOOKUP etc, so the file is looking from a side,
a bit complex,

So my question is does the formulas as SUMPRODUCT increases the file more
than let say the ordinary functions as SUM, or "+", or "*",... is it the
problem in too long formulas...

Also, the file is linked with few other files, does the number of links
increases the file,

And at the end how can I decrease the file, let say by deleting necessary
formats, .. anything, any idea will help me

Tx in advance

Emilija