I think, if manual refresh is working fine, then there might be some issue with vba code that you used for refreshing query, please share your vba code and your screenshot shows the connection is not established successfully and it is keep on trying to connect.☺️

If you want to find accurate multiple values of 0.25, you could divide the values from highlighted cell by 0.25 and if you find no decimal value that would be the accurate multiple of 0.25, e.g. 1.00/0.25 = 4 accurate time, 3.26/0.25=13.04 not accurate. Note: this is as per my understanding of your query.