Limitation of calculations in spreadsheets

G

Guy

I was just told that excel has a limitation on the number of
calculations that can exists on a single sheet/workbook. Can someone
validate this statement?

Thanks in advance!

Guy Normandeau
 
A

Adam

No I dont think there are, well theres only limited to
the processing power your machine can handle before a
stall.

If they are referring to a particular formula limitation
then it depends on the formula.
 
J

J.E. McGimpsey

You can have a maximum of 16,777,216 calculations on any single
spreadsheet. But that's only because there are only 16,777,216 cells.

Workbooks have no limitation other than your "system resources"
(memory and processor speed). In practice, I've found XL files
become unwieldy when they start getting above 20MB or so. Some get
sluggish much sooner if there are lots of processor intensive
functions (e.g., lookups, string functions)
 
Top