Try placing the following code in each Sheet object in your workbook
VBAProject.

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Calculate
End Sub


"VBA Dabbler" wrote:

Try the following:

Application.CalculateFull

It forces recalculation of all open workbooks.

If you want more control of the scope of the calculation, then use:

expression.Calculate

Regards,
VBA Dabbler

"Floyd" wrote:

Sorry, I should have stated this in my original post.

On Tools-Options-Calculation Tab

Calculations are set to Automatic.