| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit To Number Of Named Formulas? | Excel Discussion (Misc queries) | |||
| How to limit number of rows and column in worksheet? | Excel Discussion (Misc queries) | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
![Del[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
