Forum Discussion
Craig Barnes
Jun 27, 2018Copper Contributor
copied formulas not computing properly in excel
When I copy a formula to another line it instead shows the result of the formula copied. Example: I copy =SUM(A1/B1) to line below. Even though this entry on the second line reads =SUM(A2/B2) the...
SergeiBaklan
Jun 27, 2018Diamond Contributor
Hi Craig,
Please be sure your calculate options (Formulsa->Calculate options) is set to Automatic. Default setting is in File->Options->Formulas
- Craig BarnesJun 27, 2018Copper ContributorWorked - Thanks!