Excel Power Query connection to ODBC - issue with ODBC response

I am trying to automate a spreadsheet that connects to an ODBC source and pulls information, formats it and then emails it out. I can get the spreadsheet to work some of the time but not all of the time. The issue appears to be when I have been idle for over an hour.

I am using this line in VBA to update the query:

Range("'simplequery'!A1").ListObject.QueryTable.Refresh BackgroundQuery:=False

If I have been actively pulling information this works without a problem but if I have been idle I get a pop up in excel saying:

Teradata TDATA.DLL

10060 WSA E TimedOut No response received when attempting to connect to the teradata server

If I click the okay button and try again, it works just fine but I want to be able to be away from my computer and have this run...

Is there a way to deal with the ODBC response that would just effectively click "OK" on that message? I can build in a 'try again' method but I cannot figure out how to deal with acknowledge that response.

I have tried to disable alerts but it still pops up. I have tried error handling but it will not go into error handling until I have accepted that message. (I also tried the combination of disable alerts and error handling with no success)

I have searched for 2 days trying to find a way to deal with this but cannot seem to find a solution. Any help is appreciated!