#Requires -Version 5.1
<#
    JbTecWiz Support Centre -- generated fix script

    Fault : Office applications open slowly, hang, or start with a blank window
    Fix   : Remove the startup dependencies outside Office
    Source: https://jbtecwiz.com/support/win-app-excel-slow

    Run as     : Elevated PowerShell
    Expect     : 25 minutes
    Risk       : low
    Reversible : yes

    WHEN THIS IS THE RIGHT FIX
    Safe mode is also slow. The delay is something Office is waiting for,
    not something it is loading.

    HOW TO UNDO IT
    Set the default printer back and re-map any drives that are still
    needed.

    This script walks the fix one step at a time and asks before each
    one. Steps with no command are things you do yourself -- it prints
    those and waits. Run with -DryRun to print without executing.

    --------------------------------------------------------------------
    NO WARRANTY - USE AT YOUR OWN RISK

    This script is provided by JbTecWiz as-is and with no warranty of any
    kind, express or implied. You run it entirely at your own risk.

    JbTecWiz accepts no liability for any loss or damage arising from its
    use, including but not limited to data loss, downtime, or configuration
    changes that turn out to be wrong for your system.

    You are responsible for reading this script before running it, for
    satisfying yourself that it suits the machine in front of you, and for
    having a working backup first. Some steps cannot be undone.
    --------------------------------------------------------------------
#>

[CmdletBinding()]
param(
    # Print every step and command without running anything.
    [switch]$DryRun,
    # Do not ask before each step. Read the script first if you use this.
    [switch]$Unattended
)

$ErrorActionPreference = 'Stop'
$script:Failed = 0

function Write-Rule { param([string]$Text)
    Write-Host ''
    Write-Host ('-' * 70) -ForegroundColor DarkGray
    if ($Text) { Write-Host $Text -ForegroundColor Cyan }
}

function Show-Prose { param([string]$Text, [string]$Colour = "Gray")
    if (-not $Text) { return }
    $words = $Text -split "\s+"; $line = "  "
    foreach ($w in $words) {
        if (($line.Length + $w.Length) -gt 74) { Write-Host $line -ForegroundColor $Colour; $line = "  " }
        $line += "$w "
    }
    if ($line.Trim()) { Write-Host $line -ForegroundColor $Colour }
}

function Invoke-Step {
    param(
        [int]$Number, [string]$Do, [string]$Why,
        [scriptblock]$Command, [switch]$Manual, [string]$Shell = "powershell"
    )
    Write-Rule "  Step $Number of 4"
    Show-Prose $Do "White"
    if ($Why) { Write-Host ""; Show-Prose $Why "DarkGray" }

    if ($Manual) {
        Write-Host ''
        Write-Host '  -> Do this yourself, then press Enter to carry on.' -ForegroundColor Yellow
        if (-not $Unattended -and -not $DryRun) { [void](Read-Host) }
        return
    }

    Write-Host ''
    foreach ($l in ($Command.ToString().Trim() -split "`n")) {
        Write-Host ("    " + $l.Trim()) -ForegroundColor Green
    }
    Write-Host ''

    if ($DryRun) { Write-Host "  (dry run -- not executed)" -ForegroundColor DarkGray; return }
    if (-not $Unattended) {
        $a = Read-Host "  Run this step? [Y]es / [S]kip / [Q]uit"
        if ($a -match "^[Qq]") { Write-Host "  Stopped at your request."; exit 0 }
        if ($a -match "^[Ss]") { Write-Host "  Skipped." -ForegroundColor DarkGray; return }
    }
    try { & $Command }
    catch {
        $script:Failed++
        Write-Host ("  Step $Number failed: " + $_.Exception.Message) -ForegroundColor Red
        Show-Prose "The rest of the fix may depend on this. Read the write-up before carrying on." "Red"
        if (-not $Unattended) {
            $c = Read-Host "  Carry on anyway? [y/N]"
            if ($c -notmatch "^[Yy]") { exit 1 }
        }
    }
}

Write-Rule
Write-Host '  Office applications open slowly, hang, or start with a blank window' -ForegroundColor White
Write-Host '  Remove the startup dependencies outside Office' -ForegroundColor Cyan
Write-Host ''
Write-Host '  Risk: low   Reversible   25 minutes'
Write-Host ''
Show-Prose 'No warranty. Use at your own risk - JbTecWiz accepts no liability. Read it before you run it, and have a backup.' 'DarkYellow'
Write-Rule

if (-not $Unattended -and -not $DryRun) {
    $go = Read-Host '  Ready? [y/N]'
    if ($go -notmatch "^[Yy]") { Write-Host "  Nothing was changed."; exit 0 }
}

Invoke-Step -Number 1 -Do 'Set the default printer to Microsoft Print to PDF temporarily and test.' -Why 'Office queries the default printer''s capabilities when it starts. If that printer is on a server that is off or unreachable, the query blocks until it times out -- typically thirty to sixty seconds, exactly the delay being described.' -Command {
    Get-CimInstance Win32_Printer | Where-Object Default -eq $true | Format-List Name,PortName,WorkOffline
}

Invoke-Step -Number 2 -Do 'Check for disconnected mapped drives, which have the same effect via the recent files list.' -Command {
    cmd.exe /c 'Get-PSDrive -PSProvider FileSystem | Format-Table Name,Root,Used,Free & net use'
}

Invoke-Step -Number 3 -Do 'Clear the recent documents list if it references a share that no longer exists.' -Command {
    Remove-Item "$env:APPDATA\Microsoft\Office\Recent\*" -Force -ErrorAction SilentlyContinue
}

Invoke-Step -Number 4 -Do 'Check the default save location under File -> Options -> Save. A default set to an unreachable share delays every open and save.' -Manual

Write-Rule "  Confirm it worked"
Show-Prose 'The application opens in a few seconds with the correct default printer restored.' 'White'

Write-Rule
if ($script:Failed -gt 0) {
    Write-Host ("  Finished with " + $script:Failed + " failed step(s).") -ForegroundColor Yellow
    Show-Prose 'Read the full write-up at https://jbtecwiz.com/support/win-app-excel-slow' 'Yellow'
} else {
    Write-Host '  Finished.' -ForegroundColor Green
}
Write-Host ''
Show-Prose 'To undo: Set the default printer back and re-map any drives that are still needed.' 'DarkGray'
Write-Rule