I have a QueryTable Object on the Excel spreadsheet. It always works when I use the External Data menu to refresh it. It will only work at the first refresh when I use the VBA to refresh it. The code is the following.
The good news is I figure out a workaround solution. By specifying the parameter, the same QueryTable works.