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.)
Bookmarks