Powershell excel刷新失败，当.visible=$false时“被Callee拒绝调用”

I've had this issue for a long time now and had just ignored it out of laziness, however I now need to find a solution. I have a script which automates refreshing a large number of excel documents. This works well and dandy, however, it fails if I have the Visible property set to false on workbooks which are stored on a network share. I've had this issue for a long time now and had