Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
what is the maximum no of formula's in 1 spreadsheet?
I have a large spreadsheet that I am informed may "fall over" due to the no
of formula's in it - how can I tell when it is getting to the limit of its maximum no of formula's? |
#2
|
|||
|
|||
I've never had a workbook "fall over" because of the number of formulas on the
worksheets. I have it slow to a crawl with large numbers of formulas, though. Usually they were =vlookup()'s dragged down a giant column and a table that was very, very large. But I'm not sure what "fall over" means, either. You may want to visit Charles Williams' web site: http://www.DecisionModels.com/calcsecrets.htm He has a few tips that may help. chris warrington wrote: I have a large spreadsheet that I am informed may "fall over" due to the no of formula's in it - how can I tell when it is getting to the limit of its maximum no of formula's? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |