Is there any way to get power pivot to recalculate measure (formulas) through VBA.
Right now, I take some user input in a cell. The cell is a single column-single row table that is setup as a linked table in Power Pivot data model.
I use that value to calculate some measures. So based on user input the values in the measures changes.
Currently, I need to open Power Pivot Window (this recalculates all the measures) and switch back to the normal excel window and refresh pivots. I want to avoid the opening of the power pivot window part.
Is it possible?
Or as a workaround, is it possible to have a macro that opens a power-pivot window and closes it?
Right now, I take some user input in a cell. The cell is a single column-single row table that is setup as a linked table in Power Pivot data model.
I use that value to calculate some measures. So based on user input the values in the measures changes.
Currently, I need to open Power Pivot Window (this recalculates all the measures) and switch back to the normal excel window and refresh pivots. I want to avoid the opening of the power pivot window part.
Is it possible?
Or as a workaround, is it possible to have a macro that opens a power-pivot window and closes it?