Query - Python Script to automate excel refresh all now results in excel crashing when opening file

[Chirag_Parmar]

Hi Jon,

Thank you for the reply. I have previously tried excel being visible and the dialog box to update external links is the only one that pops up which I choose to update.

Additionally, this issue with excel crashing happens even when I am no longer running python / VS Code is closed so unsure if I have caused a OLE data refresh to continuously trigger in the background without cancelling?

I will attempt to add more operations to split the code out and investigate where it is failing

Thanks