ExcelBanter - formulas in spreadsheet do'nt resond to changes

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

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

- - formulas in spreadsheet do'nt resond to changes (https://www.excelbanter.com/excel-worksheet-functions/25188-formulas-spreadsheet-dont-resond-changes.html)

scuba51

formulas in spreadsheet do'nt resond to changes

all of a sudden my formulas in my spreadsheets (in all my workbooks) do not
accept any changes when I change my source cell. How do I fix it?

Peo Sjoblom

Toolsoptionscalculations and set it to automatic
or press F9

Regards,

Peo Sjoblom

"scuba51" wrote:

all of a sudden my formulas in my spreadsheets (in all my workbooks) do not
accept any changes when I change my source cell. How do I fix it?

scuba51

your the best

"Peo Sjoblom" wrote:

Toolsoptionscalculations and set it to automatic
or press F9

Regards,

Peo Sjoblom

"scuba51" wrote:

all of a sudden my formulas in my spreadsheets (in all my workbooks) do not
accept any changes when I change my source cell. How do I fix it?

All times are GMT +1. The time now is 07:45 AM.