[Python] Xlwings Excel and Windows Task Scheduler issues

I have a python script that runs perfectly when I manually run the python script. It opens a shared excel file, adds data to the bottom of the sheet in real time with other users in the file, auto saves and closes. However, when I schedule this task with windows task scheduler on windows 10, it opens the file, but does not show other users in the excel file, nor will it auto save.

any ideas on how to get it to open excel properly and update in real time?

wb = xw.Book('Pending Tracker.xlsx')
ws = wb.sheets['Pendings']
val = ws.range('A1').end('down').offset(row_offset=1, column_offset=0).options(index=False,
header=False).value = comparison_df
time.sleep(20)
wb.app.quit()


Photo of Task Scheduler Setup

Continue reading...