Automate Excel workbook refresh
We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views show...
Forum Discussion
I have done this using VBA. Below is an example, the design and reference guide has the available subroutines like RefreshCubeViewsForActiveWorkSheet or RefreshCubeViews. If you cant pull everything in one refresh, you can loop through each sheet and call the Refresh for the active sheet. I am not sure if this is doable for table views though.
Sub RefreshXFFunctions()
Set xfAddIn = Application.COMAddIns("OneStreamExcelAddIn")
If Not xfAddIn Is Nothing Then
If Not xfAddIn.Object Is Nothing Then
Call xfAddIn.Object.RefreshXFFunctions
End If
End If
End Sub