Powershell/Vba 关于打开Excel时出现We can't update some of the links in your workbook

我们通过Powershell 或者 Vba打开Excel时，有时候会出现如下这种框：

还有一种框是updateXXX link，这种框跟上述图片一样，都是为了提示用户EXCEL里面有公式，但是对于Script并不友好，我们可以使用Code解决：

Powershell 写法：

在打开Excel Path写一句$xlapp.application.AskToUpdateLinks = $false;() 和 $xlapp.application.displayAlerts = $false;

$xlapp = New-Object -ComObject "Excel.Application";
$xlapp.visible = $true;
$xlapp.application.AskToUpdateLinks = $false;
$xlapp.application.displayAlerts = $false;
$wb = $xlapp.workbooks.open("Excel Path");
$wb.close($false);
$xlapp.application.displayAlerts = $true;
$xlapp.application.AskToUpdateLinks = $true;
$xlapp.quit();
$wb = $null;$xlapp = $null;
[Gc]::Collect();

Vba 写法：

Sub test()
Dim wb As Workbook
Application.AskToUpdateLinks = False
Application.DisplayAlerts = False
wb = Workbooks.Open("Excel Path")

wb.Close (False)
Application.AskToUpdateLinks = True
Application.DisplayAlerts = True
Set wb = Nothing
End Sub