Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with function / Formula | Excel Worksheet Functions | |||
Help with OR function in IF function formula | Excel Worksheet Functions | |||
how do i add a function to a formula? | Excel Discussion (Misc queries) | |||
A formula/function to return a formula/function | Excel Worksheet Functions | |||
Formula/function | Excel Worksheet Functions |