CODEWITHSUNDEEP
excelvbabusiness-intelligencejedox
Michi
Michi

Reputation: 5471

Stop BI-Excel Add-In (Jedox) from recalculating when values loaded into ComboBox

I get values in a ComboBox in a UserForm:

Sub UserForm_Activate()
ComboBox1.List = Sheet1.Range("A1:A4").Value
End Sub

The values in A1:A4 are Q1, Q2, Q3, Q4

I use a BI-Tool called Jedox as Excel AddIn. The tool inserts values from a BI-Cube into my Excel spreadsheet using specific formulas in the cells.

Once I click the Userform to load it also triggers the BI-Tool (Jedox) to re-calculate all values in every sheet. Is there a way to avoid this re-calculating?

Keep in mind that once the filter is selected the re-calculating should be done because the filter should trigger an update of the values.

Upvotes: 0

Views: 161

Answers (1)

Solar Mike
Solar Mike

Reputation: 8375

So how about:

Application.Calculation = xlmanual

your code

Application.Calculation = xlAutomatic

Upvotes: 0

Related Questions