Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? -- Jerry Edge |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
May be you are working on a file created in 2003 format - xls extension.
Save it as an xlsx file then you will get the increased numbers of If "Jerry Edge" wrote: I am working on a nested formula and if I put more than 7 formulas I get as message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? -- Jerry Edge |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
I have tried in xlsx, xlsm and xlsb and they all give me the same message. I
also get a message that the following feature cannot be saved in macro-free workbook .VB project. It will not let me save it with a macro -- Jerry Edge "Sheeloo" wrote: May be you are working on a file created in 2003 format - xls extension. Save it as an xlsx file then you will get the increased numbers of If "Jerry Edge" wrote: I am working on a nested formula and if I put more than 7 formulas I get as message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? -- Jerry Edge |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
I tested with the following;
=IF(A1<10,IF(A1<9,IF(A1<8,IF(A1<7,IF(A1<6,IF(A1<5, IF(A1<4,IF(A1<3,IF(A1<2,"<=1","=2"),"=3"),"=4") ,"=5"),"=6"),"=7"),"=8"),"=9"),"=10") "Jerry Edge" wrote: I have tried in xlsx, xlsm and xlsb and they all give me the same message. I also get a message that the following feature cannot be saved in macro-free workbook .VB project. It will not let me save it with a macro -- Jerry Edge "Sheeloo" wrote: May be you are working on a file created in 2003 format - xls extension. Save it as an xlsx file then you will get the increased numbers of If "Jerry Edge" wrote: I am working on a nested formula and if I put more than 7 formulas I get as message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? -- Jerry Edge |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
On Thu, 14 May 2009 15:13:01 -0700, Jerry Edge wrote:
I am working on a nested formula and if I put more than 7 formulas I get as message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? "to many formulas" is not an error message that you would get related to excessive nesting (even in prior versions of Excel). Is that really what the error message says? --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
I seem to have worked this on out. It now works. But yoiu are right, the
error message stated that it could not be saved in that format or workd to that effect. I have another issue. I cannot save a file in with an xlsx format which is 2007 standard file format, with a visual basic program. I have a program that changes the size of a drop down box so that I can rerad it when i click on it and then it boes bask to normal size when I click out of the cell. When I try to save it with a xlsx extension I get the message, "following feature cannot be saved in macro-free workbook .VB project Save in another format." Jerry -- Jerry Edge "Ron Rosenfeld" wrote: On Thu, 14 May 2009 15:13:01 -0700, Jerry Edge wrote: I am working on a nested formula and if I put more than 7 formulas I get as message that I have to many formulas, yet according to Excel 2007 help I should be able to nest 64 formulas. Am i reading that wrong or is something else going on? "to many formulas" is not an error message that you would get related to excessive nesting (even in prior versions of Excel). Is that really what the error message says? --ron |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote:
I seem to have worked this on out. It now works. But yoiu are right, the error message stated that it could not be saved in that format or workd to that effect. I have another issue. I cannot save a file in with an xlsx format which is 2007 standard file format, with a visual basic program. I have a program that changes the size of a drop down box so that I can rerad it when i click on it and then it boes bask to normal size when I click out of the cell. When I try to save it with a xlsx extension I get the message, "following feature cannot be saved in macro-free workbook .VB project Save in another format." Jerry Why can't you use one of the formats that allows you to save macros? --ron |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote:
I seem to have worked this on out. It now works. But yoiu are right, the error message stated that it could not be saved in that format or workd to that effect. That makes more sense. You were probably trying to save a workbook that had more than seven levels of nesting, as a 97-2003 compatible file. --ron |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits on nested formulas
I can and have but wanted to save in xlsx since I am sending the worksheet
out to many people, many who do not know anything about formats. It should work unless they try to change it. Thanks for your help. Jerry-- Jerry Edge "Ron Rosenfeld" wrote: On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote: I seem to have worked this on out. It now works. But yoiu are right, the error message stated that it could not be saved in that format or workd to that effect. I have another issue. I cannot save a file in with an xlsx format which is 2007 standard file format, with a visual basic program. I have a program that changes the size of a drop down box so that I can rerad it when i click on it and then it boes bask to normal size when I click out of the cell. When I try to save it with a xlsx extension I get the message, "following feature cannot be saved in macro-free workbook .VB project Save in another format." Jerry Why can't you use one of the formats that allows you to save macros? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formulas | Excel Worksheet Functions | |||
NESTED OR FORMULAS | Excel Discussion (Misc queries) | |||
Nested IF Limits | Excel Discussion (Misc queries) | |||
Overcoming Nested IF limits | Excel Discussion (Misc queries) | |||
nested formulas | Excel Discussion (Misc queries) |