Refresh Specific xPathOnUrl Cells Only

Support
#1

I'm using xpathonurl function for fetching remote data. I am using this code as below.
But this code refreshing and recalculating all cells and sheet. It taking long time process.

How can i refresh just xpathonurl cells ?
My xpath cells range O15:AB32

Sub AUTO_OPEN()
DoEvents
Application.OnTime Now + TimeValue("00:00:05"), "Refresh"
End Sub

Sub Refresh()
DoEvents
Application.CalculateFull
ActiveWorkbook.RefreshAll
Application.OnTime Now + TimeValue("00:02:02"), "Refresh"
End Sub

#2

How about using an if statement in your xPathOnUrl formulas which is triggered in your VBA code or other method?

For example, =if(cell=1,xpath...

Then change the cell from 1 to 0 and back to 1?

#3

is it not the setting from "formulas → calculation → automatic/manual etc.."?