Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max-ing excel out
does anyone know how to tell if i'm "max-ing" excel out with all the
formulas, conditional formats, tabs, etc i have in a file. I have a model that is fine for 20 of my users but for my user with the most data, the file sometimes acts funky....like the view code/event code doesn't work, the conditioanl formatting comes undone, just didn't know if there was a way to see if i'm "max-ed" out and should'nt put any more tabs or calcutions in... the file bytes are 5533kb and has 15 tabs |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max-ing excel out
I regularly use files that are much larger than 5.5Mb, so Excel can
handle that. Pete On Sep 5, 6:21*pm, Tami wrote: does anyone know how to tell if i'm "max-ing" excel out with all the formulas, conditional formats, tabs, etc i have in a file. *I have a model that is fine for 20 of my users but for my user with the most data, the file sometimes acts funky....like the view code/event code doesn't work, the conditioanl formatting comes undone, just didn't know if there was a way to see if i'm "max-ed" out and should'nt put any more tabs or calcutions in.... the file bytes are 5533kb and has 15 tabs |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max-ing excel out
great, thanks pete.
question: is 5.5 KB in data (ie. values in majority of cells) the same as 5.5kb with formulas in majority cells (ie. sumproducts, sumifs, vlookups, etc) "Pete_UK" wrote: I regularly use files that are much larger than 5.5Mb, so Excel can handle that. Pete On Sep 5, 6:21 pm, Tami wrote: does anyone know how to tell if i'm "max-ing" excel out with all the formulas, conditional formats, tabs, etc i have in a file. I have a model that is fine for 20 of my users but for my user with the most data, the file sometimes acts funky....like the view code/event code doesn't work, the conditioanl formatting comes undone, just didn't know if there was a way to see if i'm "max-ed" out and should'nt put any more tabs or calcutions in.... the file bytes are 5533kb and has 15 tabs |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max-ing excel out
5.5MB is 5.5MB
If your workbook contains a multitude of dependent formulas, calculation can certainly slow things down. Your formulas could be referencing entire columns or ranges much larger than needed and some Functions create more overhead than others. See Charles Williams' site for tips on calculation and how to find/cure bottlenecks. http://www.decisionmodels.com/optspeedb.htm Gord Dibben MS Excel MVP On Sun, 6 Sep 2009 06:24:01 -0700, Tami wrote: great, thanks pete. question: is 5.5 KB in data (ie. values in majority of cells) the same as 5.5kb with formulas in majority cells (ie. sumproducts, sumifs, vlookups, etc) "Pete_UK" wrote: I regularly use files that are much larger than 5.5Mb, so Excel can handle that. Pete On Sep 5, 6:21 pm, Tami wrote: does anyone know how to tell if i'm "max-ing" excel out with all the formulas, conditional formats, tabs, etc i have in a file. I have a model that is fine for 20 of my users but for my user with the most data, the file sometimes acts funky....like the view code/event code doesn't work, the conditioanl formatting comes undone, just didn't know if there was a way to see if i'm "max-ed" out and should'nt put any more tabs or calcutions in.... the file bytes are 5533kb and has 15 tabs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|