Thank you! I had so many issues still with all methods. I ended up putting a macro in the workbook that connects the data source, updates it, then unlinks it. So far no issues.