Preciso Aumentar a quantidade de calculo automático em um formulario... alguém sabe como aumentar as interações...
Quando calculo está formula ele faz automático
=([Espessura]/1000)*(([L01]/100)*[C01]*[Q01])+(([L02]/100)*[C02]*[Q02])+(([L03]/100)*[C03]*[Q03])+(([L04]/100)*[C04]*[Q04])+(([L05]/100)*[C05]*[Q05])+(([L06]/100)*[C06]*[Q06])+(([L07]/100)*[C07]*[Q07])+(([L08]/100)*[C08]*[Q08])+(([L09]/100)*[C09]*[Q09])+(([L10]/100)*[C10]*[Q10])+(([L11]/100)*[C11]*[Q11])+(([L12]/100)*[C12]*[Q12])+(([L13]/100)*[C13]*[Q13])+(([L14]/100)*[C14]*[Q14])+(([L15]/100)*[C15]*[Q15])+(([L16]/100)*[C16]*[Q16])+(([L17]/100)*[C17]*[Q17])+(([L18]/100)*[C18]*[Q18])+(([L19]/100)*[C19]*[Q19])+(([L20]/100)*[C20]*[Q20])
=================================================
Mas esta ele não faz... tenho que usar o F9...
=([Espessura]/1000)*(([L01]/100)*[C01]*[Q01])+(([L02]/100)*[C02]*[Q02])+(([L03]/100)*[C03]*[Q03])+(([L04]/100)*[C04]*[Q04])+(([L05]/100)*[C05]*[Q05])+(([L06]/100)*[C06]*[Q06])+(([L07]/100)*[C07]*[Q07])+(([L08]/100)*[C08]*[Q08])+(([L09]/100)*[C09]*[Q09])+(([L10]/100)*[C10]*[Q10])+(([L11]/100)*[C11]*[Q11])+(([L12]/100)*[C12]*[Q12])+(([L13]/100)*[C13]*[Q13])+(([L14]/100)*[C14]*[Q14])+(([L15]/100)*[C15]*[Q15])+(([L16]/100)*[C16]*[Q16])+(([L17]/100)*[C17]*[Q17])+(([L18]/100)*[C18]*[Q18])+(([L19]/100)*[C19]*[Q19])+(([L20]/100)*[C20]*[Q20])+(([L21]/100)*[C21]*[Q21])+(([L22]/100)*[C22]*[Q22])+(([L23]/100)*[C23]*[Q23])+(([L24]/100)*[C24]*[Q24])+(([L25]/100)*[C25]*[Q25])
Quando calculo está formula ele faz automático
=([Espessura]/1000)*(([L01]/100)*[C01]*[Q01])+(([L02]/100)*[C02]*[Q02])+(([L03]/100)*[C03]*[Q03])+(([L04]/100)*[C04]*[Q04])+(([L05]/100)*[C05]*[Q05])+(([L06]/100)*[C06]*[Q06])+(([L07]/100)*[C07]*[Q07])+(([L08]/100)*[C08]*[Q08])+(([L09]/100)*[C09]*[Q09])+(([L10]/100)*[C10]*[Q10])+(([L11]/100)*[C11]*[Q11])+(([L12]/100)*[C12]*[Q12])+(([L13]/100)*[C13]*[Q13])+(([L14]/100)*[C14]*[Q14])+(([L15]/100)*[C15]*[Q15])+(([L16]/100)*[C16]*[Q16])+(([L17]/100)*[C17]*[Q17])+(([L18]/100)*[C18]*[Q18])+(([L19]/100)*[C19]*[Q19])+(([L20]/100)*[C20]*[Q20])
=================================================
Mas esta ele não faz... tenho que usar o F9...
=([Espessura]/1000)*(([L01]/100)*[C01]*[Q01])+(([L02]/100)*[C02]*[Q02])+(([L03]/100)*[C03]*[Q03])+(([L04]/100)*[C04]*[Q04])+(([L05]/100)*[C05]*[Q05])+(([L06]/100)*[C06]*[Q06])+(([L07]/100)*[C07]*[Q07])+(([L08]/100)*[C08]*[Q08])+(([L09]/100)*[C09]*[Q09])+(([L10]/100)*[C10]*[Q10])+(([L11]/100)*[C11]*[Q11])+(([L12]/100)*[C12]*[Q12])+(([L13]/100)*[C13]*[Q13])+(([L14]/100)*[C14]*[Q14])+(([L15]/100)*[C15]*[Q15])+(([L16]/100)*[C16]*[Q16])+(([L17]/100)*[C17]*[Q17])+(([L18]/100)*[C18]*[Q18])+(([L19]/100)*[C19]*[Q19])+(([L20]/100)*[C20]*[Q20])+(([L21]/100)*[C21]*[Q21])+(([L22]/100)*[C22]*[Q22])+(([L23]/100)*[C23]*[Q23])+(([L24]/100)*[C24]*[Q24])+(([L25]/100)*[C25]*[Q25])