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

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

    Run as     : The application itself
    Expect     : 30 minutes
    Risk       : low
    Reversible : yes

    WHEN THIS IS THE RIGHT FIX
    Safe mode is fast. That result tells you it is an add-in with near
    certainty.

    HOW TO UNDO IT
    Every add-in can be re-enabled in the same dialog.

    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 5"
    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 '  Bisect the add-ins' -ForegroundColor Cyan
Write-Host ''
Write-Host '  Risk: low   Reversible   30 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 'List what is loaded and how long each took -- Office records this itself.' -Command {
    Get-ItemProperty 'HKCU:\Software\Microsoft\Office\16.0\Excel\Resiliency\StartupItems' -ErrorAction SilentlyContinue
}

Invoke-Step -Number 2 -Do 'In the application: File -> Options -> Add-ins. Manage COM Add-ins -> Go, and disable them all.' -Manual

Invoke-Step -Number 3 -Do 'Restart normally, confirm it is fast, then re-enable them one at a time, restarting between each.' -Why 'Disabling them all and leaving it there works but tells you nothing, and someone will re-enable the culprit in a month. Twenty minutes of bisecting names it permanently.' -Manual

Invoke-Step -Number 4 -Do 'Adobe, antivirus and PDF-maker add-ins are the usual culprits, and the vendor usually has a current version that behaves.' -Manual

Invoke-Step -Number 5 -Do 'Check the Disabled Items list too, which Office maintains separately: File -> Options -> Add-ins -> Manage: Disabled Items.' -Manual

Write-Rule "  Confirm it worked"
Show-Prose 'The application opens in a few seconds with the add-ins you need enabled.' '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: Every add-in can be re-enabled in the same dialog.' 'DarkGray'
Write-Rule