enable calculation iterations on excel 07 spreadsheets

[aetious1234]

Hi,

Is there a way to permanently enable excel 07 iterations? It’s on some sheets by default, others it isn’t. If I enable the check box it doesn’t stay permanently on.

On another note....

Excel sometimes crashes and freezes, I’ve noticed resource usage is high on task manager and sometimes there are problem with screen draws and refreshes, such as an old spreadsheet being shown or the desktop background showing through a spreadsheet when you’re trying to move it. Event viewer shows several of these (below), but I don’t know what to make of it. Any help much appreciated.


Faulting application excel.exe, version 12.0.6504.5001, stamp 49fea693, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x00000008.

For more information, see Help and Support Center at

http://go.microsoft.com/fwlink/events.asp.

thx

 

[xlhelp]

If the first Workbook you open has the iteration set, then subsequent workbooks will automatically have the iteration set.

Else, put the following code in Personal.XLS

Private Sub Workbook_Open()
With Application
.Calculation = xlCalculationAutomatic
.Iteration = True
.MaxIterations = 999
.MaxChange = 0.001
End With
End Sub


A man has only two choices: He can be right or he can be happy.