Limitation of calculations in spreadsheets

  • Thread starter Thread starter Guy
  • Start date Start date
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
 
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.
 
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)
 
Back
Top