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!