Excel - Unable to Save through UI Test ran using Azure Pipelines Agent

Question

I configured azure pipeline agent on my machine to run in Interactive mode. I am running a UI Test to edit and save excel file. The test will mimic the same steps we do manually to save excel file. open excel, enter some value in cell in the worksheet, click on file tab-->browse-->enter file name in save as window and click on save. I have Excel 2016 Desktop App installed and activated on agent machine. The excel is saving the file as Book1 (The default Name) instead of the name I provided. Not sure why the issue. I can save the excel file manually with the same user. All folder and remote access permissions for excel app are configured in Component Services ( DCOM Config) for the user. Am i missing something over here or in the agent configuration. Thanks