This VBA MACRO can help you to refresh selected cells. If you are working on a large and complex data then macros come handy.I found this one from a forum for my friend he used to work for a company where they have to crunch large workbooks. He had to refresh a particular cell or a group of cells again and again.

 

Here is the code. You have to place error handling near the ‘Set rng’ line.

Public Sub RecalculateSelection()
Dim rng As Range
Set rng = Application.Selection
rng.Calculate
End Sub

Here is another VBA function that can update or refresh cells automatically whenever there is a change in workbook.

Private Sub Worksheet_Change(ByVal Target As Range)
If GetXLCol(Target.Column) = "G" Then
Calculate
End If
End Sub

Now if you want to recalculate whole spreadsheet use this command :

Calculate

The another command

Worksheets(“sheet1”).Calculate

will recalc only the specific workbook, to recalculate a specific range i would suggest you to try

Range(“A1:C5”).Calculate

One can also download this RangeCalc command button that will perform the same function,it works in excel 2007,2010