ExcelBanter - excel formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel formulas (https://www.excelbanter.com/excel-worksheet-functions/168118-excel-formulas.html)

bobbi

excel formulas

my formulas aren't recalculating in excel. (i used to be able to copy and
paste and change numbers and it would recalc) the formula is correct when
you look at it but it will only calculate if you click on the formula again
in the input area and then hit enter.

Gord Dibben

excel formulas

ToolsOptionsCalculation.

Set it to Automatic.

Gord Dibben MS Excel MVP

On Sat, 1 Dec 2007 08:43:00 -0800, bobbi
wrote:

my formulas aren't recalculating in excel. (i used to be able to copy and
paste and change numbers and it would recalc) the formula is correct when
you look at it but it will only calculate if you click on the formula again
in the input area and then hit enter.

All times are GMT +1. The time now is 04:44 PM.