| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the upper limit to the dependencies for Excel?
If I have a particularly complicated spreadsheet with many formulae (talking
thousands and thousands of rows here)? Excel has an upper limit to the dependencies it can keep track of (required to permit operation of its smart recalculation engine). Does anyone know the upper limit to the dependencies for Excel 2003 and 2007? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the upper limit to the dependencies for Excel?
Excel 2007:
http://office.microsoft.com/en-us/ex...33#Calculation Excel 2003: http://office.microsoft.com/en-us/ex...CH062527721033 "Eric" wrote: If I have a particularly complicated spreadsheet with many formulae (talking thousands and thousands of rows here)? Excel has an upper limit to the dependencies it can keep track of (required to permit operation of its smart recalculation engine). Does anyone know the upper limit to the dependencies for Excel 2003 and 2007? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the upper limit to the dependencies for Excel?
see http://www.decisionmodels.com/calcsecretsf.htm
Charles _________________________________________ FastExcel 2.3 Name Manager 4.0 http://www.DecisionModels.com "Eric" wrote in message ... If I have a particularly complicated spreadsheet with many formulae (talking thousands and thousands of rows here)? Excel has an upper limit to the dependencies it can keep track of (required to permit operation of its smart recalculation engine). Does anyone know the upper limit to the dependencies for Excel 2003 and 2007? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Lists Dependencies | New Users to Excel | |||
| create SPC chart with 3 sigma Upper/Lower control limit | Charts and Charting in Excel | |||
| Count occurence with user defined upper&lower limit. | Excel Worksheet Functions | |||
| Is there an upper limit of text that comments can hold | Excel Discussion (Misc queries) | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Linear Mode
