max-ing excel out

  • Thread starter Thread starter Tami
  • Start date Start date
T

Tami

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
 
I regularly use files that are much larger than 5.5Mb, so Excel can
handle that.

Pete
 
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)
 
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
 
Back
Top