Automatically refresh Excel ODC connections and pivots without opening the file PowerShell

Possibly the answer on this question can help. The perl script is also available as a pre-compiled exe file.

I would approach this issue by using Excel VBA, and create your Excel file into a .xlsm.

Then update the file w/ Excel VBA commands and functions to refresh your odbc connection, and then save as a new file for distribution.