update links using win32com where excel is linked with multiple sources

excel.AskToUpdateLinks = False

As far as I know, the above turns off the prompt and automatically update external links as a file is open. Try use below:

excel = win32com.client.Dispatch("Excel.Application")
excel.DisplayAlerts = False
workbook = excel.Workbooks.Open(Path to file,UpdateLinks=0)

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top