your entry cannot be used. an integer or decimal may be required

I want to change the maximum change under options > formulas to 0.001, but it keeps showing the error: your entry cannot be used. an integer or decimal may be required

Even my (point)/delete button on the keyboard will show a (point) in word when I use it, but in excel it shows a (comma)

I tried the below from an old thread from 2005, but it didn't work

Open a new workbook
hit alt-f11 (to get to the vbe.
hit ctrl-r (to see the project explorer)
locate your workbook's project.

It should look like:
VBAProject(Book1)

Right click on that and select Insert|Module.
Paste this in:

Option Explicit
Sub testme()
With Application
.Calculation = xlManual
.Iteration = True
.MaxChange = 0.001
End With
End Sub

Put your cursor inside that macro (click on With).
Hit F5 (to run the code).

Then alt-f11 to get back to excel.
Can you get to tools|Options|calculation tab
(And change the calculation back to automatic, too.)

It has been some time since I used Excel 2007 or even 2010 but in later versions (2016) you can set the default settings in the File tab.

In 2016 click File tab / options
Select Formula to set calculation either automatic/Manual also the number of iterations and maximum change (ie .001)

Select Advanced / scroll to editing options to set decimal indicator to period.

If this works for you it would save having to run a macro on start up or when you wanted a change. As I said I cannot check this against earlier versions but hope it helps.

Cheers

Thanks, looks liked it worked

Glad to have helped