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.