refresh calculations and external data
 

Sub mcrRefresh()
Activesheet.Cells.Select
Selection.Calculate
End Sub

This will get the formulas on the worksheet updated.
I'm not sure how to refresh the external data on the hour unless you
used a timer like this one:
http://www.cpearson.com/excel/ontime.htm

Commands to refresh external data would look something like this if it
were a querytable...

Sub rfsh()
For Each QueryTable In ActiveSheet.QueryTables
QueryTable.Refresh
Next
End Sub


Lottie wrote:
I have a complex workbook with 12 worksheets full of formulas and external
data links. The calculations work off the external links. I would like to
build a button that allows the users to refresh all the external data and
calculations on the hour. After reading some articles on this I should be
able to use the F9 button to refresh the whole worksheet. This does not work
if I either set the options to manually calculate or automatically calculate,
however the Ctrl + Alt + F9 works but calculates the whole workbook which
take a lot of time. Is there a way to build a button that calls a macro to do
this?

I used the following but it does not seem to work.

Sub mcrRefresh()
ActiveWorkbook.RefreshAll
End Sub

I also read to use the external data toolbar to refresh the data but this
does not seem to work either.

Thanks for your help!