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 :
The another command
will recalc only the specific workbook, to recalculate a specific range i would suggest you to try
One can also download this RangeCalc command button that will perform the same function,it works in excel 2007,2010