Excel calculations not updating
Status Bar = Format(fraction Done, "0%") & "done..." ' or, alternatively: ' status Range.value = Format(fraction Done, "0%") & "done..." ' Some code.......Next i Sub Progress Meter() Dim boo Status Bar State As Boolean Dim i Max As Integer Dim i As Integer i Max = 10000 Application.Be aware that a circular reference can, in some instances, prevent Excel from calculating a formula.Correct the circular reference and recalculate your spreadsheet.Look at the bottom of the Excel window for the words CIRCULAR REFERENCES.Like circular logic, a circular reference is a formula that either includes itself in its calculation or refers to another cell which depends on itself.My Excel tool performs a long task, and I'm trying to be kind to the user by providing a progress report in the status bar, or in some cell in the sheet, as shown below.But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.
The following commands seem to do the trick: This is not directly answering your question at all, but simply providing an alternative.
Screen Updating = False ''//Turn off screen updating boo Status Bar State = Application.
Display Status Bar ''//Get the statusbar display setting Application.
When a cell formatted as General and the cell contains a reference to another cell, Excel copies the format of the referenced cell.
Choosing any format other than General will prevent Excel from changing the format.