Refresh Live Office Objects Using Macro (Excel 2007)
Add ComAddins in Excel book
crystal_addin_framework.dll this is Live office related Addins.
Active particular worksheet and use below code to refresh
Set crysAddinObj = Application.COMAddIns.Item(1).Object
crysAddinObj.liveObjects.Refresh True