Hello,
I have created a Power Query that pulls data from SalesForce in a live queue that I built and I have it refreshing every 1 minute with the below VBA. My only problem is when I create formula's in additional columns next to the table that is created with the power query the formulas change if my pivot table reduces the amount of rows. Is there any way to get the formulas to not change? I've tried locking the cells, that didn't work. I've tried adding "$" (ex. $A$1) to the formula's and that didn't' work. Any help would be appreciated.
Sub my_onTime()
Application.OnTime Now + TimeValue("00:01:00"), "my_Procedure"
End Sub
Sub my_Procedure()
Workbooks("Cases In Queue Unasigned").RefreshAll
my_onTime
End Sub
I have created a Power Query that pulls data from SalesForce in a live queue that I built and I have it refreshing every 1 minute with the below VBA. My only problem is when I create formula's in additional columns next to the table that is created with the power query the formulas change if my pivot table reduces the amount of rows. Is there any way to get the formulas to not change? I've tried locking the cells, that didn't work. I've tried adding "$" (ex. $A$1) to the formula's and that didn't' work. Any help would be appreciated.
Sub my_onTime()
Application.OnTime Now + TimeValue("00:01:00"), "my_Procedure"
End Sub
Sub my_Procedure()
Workbooks("Cases In Queue Unasigned").RefreshAll
my_onTime
End Sub
