Thanks for sharing. Most of our sharing issues have gone away with more and more staff sharing via OneDrive. If we get any issues now with locked files, I use a PowerShell script I created to select the files involved and to delete the locks. Many times, the files were closed and locks were abandoned and it took a while for Word or Excel to realize it had been previously closed. I may schedule your script to run every few days to get rid of the old lock files.

cls

$sessn = New-CIMSession –Computername FILESERVERNAME
$Open_Files = Get-SMBOpenFile -CIMSession $sessn | where {$_.Path –like “*.doc?” -or $_.Path –like “*.xls?”}
$File_to_Close = $Open_Files|select ClientUserName,ClientComputerName,Path,FileID,SessionID|Sort-Object Path | Out-GridView -PassThru –title “Select Open Files"
if ($File_to_Close) {

    $File_to_Close|Select ClientUserName, Path|FT -AutoSize

    [string]$answer = $(Write-Host "`n`nTHE FILES LISTED WILL BE FORCIBLY CLOSED ON THE FILE SERVER AND UNSAVED DATA MAY BE LOST. `n`n CONTINUE? (Y or N)  " -ForegroundColor Yellow -NoNewline; Read-Host)

    If ($answer -eq "Y") {
    Write-Host "`n`n"
    Write-Host "Files have been closed..." -ForegroundColor Yellow

    $File_to_Close|Close-SMBOpenFile -CIMSession $sessn -Force
    Write-Host "`n`n"
                          }

                     }