Powershell using Excel.Application

Question

I have a PS script that uses Excel.Application to open an excel file, refresh external data, recalculate formulas and then save the file. This works perfectly.
However if I map a network drive to a SharePoint document library it does everything except save the file.
When I do this outside of SharePoint there is no prompt to save (good)
If I do this with a xlsx file in SharePoint there is a prompt asking me if I want to over right the file, I click yes but the file is not updated.
The file is not locked. It is not lacking mandatory metadata, I have all the permissions required, I know that the work is being done but not the save.
Any idea why SharePoint would be blocking the save even when it prompts me to confirm?

Answer 1

Hi @Jay,

You can use display alerts statement before SaveAs

$excel.DisplayAlerts = $false;
$excel.ActiveWorkbook.SaveAs($xlsFile);

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.