Is there a limit to the number of formulas in an Excel worksheet?
 

Is there a limit to the number of formulas in an Excel worksheet? When I do a
function check on my formula, the function box shows the correct answer, so I
know my formula is correct. Currently I have about 250 correctly displayed
formulas on this one sheet, but I need to add 36 more.

Is there a limit to the number of formulas in an Excel worksheet?
 

The only limit is the amount of available memory.
--
Gary''s Student - gsnu200776


"Del" wrote:

Is there a limit to the number of formulas in an Excel worksheet? When I do a
function check on my formula, the function box shows the correct answer, so I
know my formula is correct. Currently I have about 250 correctly displayed
formulas on this one sheet, but I need to add 36 more.

Is there a limit to the number of formulas in an Excel worksheet?
 

Excel will easily handle 286 formulas. It will handle multi-thousands,
dependent only on memory.

Regards,
Fred.

"Del" wrote in message
...
Is there a limit to the number of formulas in an Excel worksheet? When I
do a
function check on my formula, the function box shows the correct answer,
so I
know my formula is correct. Currently I have about 250 correctly displayed
formulas on this one sheet, but I need to add 36 more.

Is there a limit to the number of formulas in an Excel worksheet?
 

On one spreadsheet I had about 2,000 very large array formulas, so you
should be safe <g.

--JP

On Mar 28, 8:49*am, Del wrote:
Is there a limit to the number of formulas in an Excel worksheet? When I do a
function check on my formula, the function box shows the correct answer, so I
know my formula is correct. Currently I have about 250 correctly displayed
formulas on this one sheet, but I need to add 36 more.