Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
no DDE connection?? | Excel Discussion (Misc queries) | |||
Excel 2007 Charts Complexity | Charts and Charting in Excel | |||
Help with connection macro? | Excel Discussion (Misc queries) | |||
Connection error | Excel Discussion (Misc queries) | |||
Changing OLE DB connection | Excel Discussion (Misc queries) |