ActiveWorkbook.RefreshAll vs Application.Calculate

[tfield98]

What's the different between:

ActiveWorkbook.RefreshAll

and

Application.Calculate

other than the latter does all open workbooks.

 

[JoeMo]

What's the different between:

ActiveWorkbook.RefreshAll

and

Application.Calculate

other than the latter does all open workbooks.

The first method refreshes all external data and pivot tables in the active workbook. The second method calculates all open workbooks.