View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Help with Function/Formula Overloads

See this:

http://www.decisionmodels.com/

--
Biff
Microsoft Excel MVP


"Rob" wrote in message
...
Hello....

I was wondering just how much Excel 2003 can take with regards to massive
amounts of Functions/Formula? I have a workbook and two worksheets have
many
functions in it and every time I make a slight change to anything it takes
about 15 minutes to recalculate everything... even if I do not make a
change
to a formula/function or the data that the are pulling from.


if there is an issue with this can someone help me with thinning out my
mess.? Currently I have on one sheet -- seven columns with 1003 rows that
have a formula/function in each and every cell. On that sheet alone that's
7021 cells with code and over 30,000 "IF" Statements/checks. On the other
sheet, I have at least 5 times as much.


Thanks In Advance!