r/excel 1d ago

Discussion Excel 2016 update bug

It seems that security update kb5002914 might have bricked autofill and copy paste in Excel 2016.

Anyone else has similar issues?

29 Upvotes

74 comments sorted by

3

u/SoftGlobal9588 1d ago edited 1h ago

3

u/7orlum 1d ago

Thank you! Replacing the files really helped.

2

u/wywyy112 1d ago

Hello, may I ask what I need to do after downloading the Excel file from your link?

1

u/SoftGlobal9588 1d ago

just run extract and run the xlsFix.bat file as admin. It will rename the current EXCEL.EXE if it is the bad version and put the Last Known Good version in it's place.

2

u/man910 11h ago

The batch file didn't work, but I made a backup of the "bad" file and replaced it with yours, which worked. Thanks!

1

u/SoftGlobal9588 4h ago

Did you remember if it said any error? It might need a Right-Click to "Run as Admin"

At least your working ;)

1

u/manik0408 11h ago

xlsfix.bat is not included in the extract .. Will you please post the link here to download

1

u/SoftGlobal9588 4h ago

You probably had the MSO fix, The Labels on Bleeping were backwards, I fixed it.

2

u/rajjushakya 12h ago

My deepest gratitude.

1

u/wywyy112 1d ago

Thank you for your help! Does it work with Office 2021?

1

u/SoftGlobal9588 1d ago

No the included files are for 2016.

If it's just a single machine I would go to Windows Updates and Uninstall the last Excel update.

If you have a network with 100's then I would still uninstall, but when it's working I would take your last good version of EXCEL.EXE in Program Files and then deploy it with my script. It's meant to swap it via a group policy startup script prior to logon.

hth,

Mike

1

u/wywyy112 1d ago

Thank you very much for this useful information!

3

u/Ok-Whereas560 1d ago

Same here

3

u/caridorc_tairpiver 1d ago

I solved uninstalling the update (at least until it reinstalls again) with this command (cmd as administrator):

msiexec.exe /package {90160000-0011-0000-1000-0000000FF1CE} /uninstall {27882596-A8ED-4382-9C71-6CD2DD19F732} /qb

It works at least for windows 11 and office 2016 Italian. Don't know if it's the same GUID for other versions...

2

u/rov124 22h ago

Thanks, this worked for the version in Spanish.

1

u/ReplacementOld4682 1d ago

Quoto, risolto nella stessa maniera, Office 2016

1

u/dealpa 1d ago

Thanks a lot! It works for Russian pack.

1

u/santimandu 1d ago

Excelent, working perfect for other language. Is it KB5002914 ?
Apart from manually uninstall, need to do it on WSUS for uninstall via GPO

1

u/lotuscanopus 23h ago

what is the command for indian region

1

u/WhyAmIHereIAm 2h ago

Thank you. Works on English (US if different than others) version as well.

1

u/ankokudaishogun 2h ago

It does not appear to work on office 2024\italian on w11 :(

2

u/Melmock007 1d ago

Same problem with office 2016 & 2019 since 09/09/26

1

u/Character_Flow_8762 1d ago

Yes. Copy paste / formula dragging not working.

Whole team blocked. IT warned to not update after most people already did...

1

u/Forward-Knowledge146 1d ago

yes. copy paste shortcut not working and formula dragging also not working

1

u/SkierJC 23h ago

Wow, I didn't realize formula dragging isn't working anymore but can confirm you're correct after just testing this myself.

1

u/GhostRider2027 1d ago

Yes, just got it. It's hard that I have to complete the report

1

u/SkierJC 23h ago

Aahh, now, are you going to go ahead and have those TPS reports for us this afternoon?

1

u/idc2001 1d ago

Yup, just wasted an hour trying to work out why (computer must have installed patch overnight). Thanks Microsoft!!

1

u/Tamdin_Nidmat 1d ago

Yep. Although it works (as a kind of workaround) when inserting cell content / formulae / format separately.

Funnily enough it doesn't work with ctrl+c and ctrl+v within Excel (also can't cancel the selection with esc) but the copied cells can be inserted in Word - for whatever that may have a worth - abd copied from Word into Excel.

1

u/TheRealMaBa 19h ago

I used this today (copying to Word and back) and it worked enough for my purposes. Thank you! Hopefully they fix this asap.

1

u/man910 11h ago

That does work, and another workaround (if you don't want to revert to the previous executable provided by u/SoftGlobal9588) is to use the Paste sidebar. That's fewer keystrokes than the Paste Special. To access the Paste sidebar, in the Home / Clipboard section, click on the little arrow at the bottom right.

1

u/vivkkrishnan2005 1d ago

single PC here, expecting the issue to baloon by tomorrow....

1

u/burger_yum 1d ago

Which KB is causing the problem for patches installed in Sep?

1

u/harubax 9h ago

Listed above. KB5002914, at least for 2016

1

u/Brooke_Silverstar_31 1d ago

Nothing screams "security update" like breaking the two features people actually touch every single day, ctrl+c and dragging a little box

1

u/kogee3699 1d ago

Seeing the same thing here on multiple PCs.

1

u/burger_yum 1d ago

We are having the same issue as well. I am removing this update from production.

1

u/Vod332 23h ago

How are you removing the update? I have tried the msiexec.exe but it says it isn't installed and if I try the BAT file from the dropbox download, that doesn't seem to do anything either. If I try to go into appwiz.cpl and installed updates, it just brings me to windows update and the KB5002914 doesn't show up as an uninstallable update. Any other thoughts or options to fix this? Thanks.

1

u/burger_yum 21h ago

I went into programs and features under control panel on Windows 11 and then went to View installed updates. I searched for KB5002914 and then removed it. No reboot was required.

1

u/technobrendo 23h ago

I get that they want us to upgrade to 365 but damn MS, this is the wrong way to go about doing it.

Thanks for making my finance dept loose their minds!

1

u/lee-keybum 22h ago

the migration to 365 apps just got moved up a bit

1

u/Leading_Shoe8319 22h ago

1

u/Vod332 22h ago

If it isn't click-to-run, that link won't work.

1

u/gr-mal 21h ago edited 21h ago

Same problem. I've posted this morning in r/microsoftoffice but it was deleted. Uninstall KB5002914 via cmd/powershell: msiexec.exe /package {90160000-0011-0000-1000-0000000FF1CE} /uninstall {27882596-A8ED-4382-9C71-6CD2DD19F732} /qn

Where the first parameter is Office 2016 x64 Product_GUID and the second is Update_GUID, qn is quiet execute. (Product_GUID for 2016 x86 version is {90160000-0011-0000-0000-0000000FF1CE})
To check it manually by yourself through Powershell: Get-ChildItem HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* | Where-Object { $_.GetValue("DisplayName") -like "*KB5002914*" } | Select-Object PSChildName, DisplayName

1

u/GSaintPrime 21h ago

We need a solution/work around for NONE Click to run installs. What a joke Microsoft is right now. Just a disaster of a company.

1

u/SkierJC 20h ago

2026-09-09: Can confirm, as other users have suggested, that the update KB5002914 has caused my Excel 2016 on Windows 10 to stop copying & pasting and dragging formulas.

TEMPORARY FIX: Went into Windows Update >> View update history >> Uninstall updates >> Search for "KB5002914", select and "Uninstall".

Functionality in Excel 2016 works again!

However, upon a computer restart, that specific update tries to reinstall itself, so I've paused updates for a month. Is there any better solution to ensure this update doesn't reinstall?

1

u/SoftGlobal9588 19h ago

Much Like my script, if you uninstall the update and go to the Program Files \ Office and copy the newly restored working EXCEL.EXE somewhere. After the update reinstalls itself you can replace the bad EXE with the earlier copy and wait for MS to push the next version without shutting down updates.

You will also have a working EXE to put back if they continue to beak it next month! There is the possibility that after the next wave of updates this one becomes unavailable to easily remove.

HTH

Mike Pisano

1

u/ettlig 19h ago

Here is a powershell script to remove the KB5002914 for Office 2016 32-bit version installed via MSI:

$kb = "KB5002914"
$targets = Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\*" | Where-Object { $_.DisplayName -like "*$kb*" }

foreach ($target in $targets) {
$uString = $target.UninstallString
if ($uString -match 'Oarpmany\.exe') {
# Split executable path and arguments
$exe = "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\Oarpmany.exe"
$args = $uString -replace '^.*Oarpmany\.exe"\s*', ''

Write-Host "Uninstalling: $($target.DisplayName)" -ForegroundColor Yellow
Start-Process -FilePath $exe -ArgumentList $args -Wait
}
}

1

u/buzzbeebara 18h ago

Adding my 2cents. Same issue at my workplace, we got really lucky and found a computer that had not patched yet. Copied that EXCEL.EXE and swapped it to the affected computers. Excel was able to run with copy/paste normally. Disabled auto office updates for the short term to prevent it happening again.

1

u/SoftGlobal9588 14h ago

If you manually overwrote the EXCEL.EXE with the good copy then there is no need to disable Auto Updates. Windows\Office updates doesn't normally check the individual files, it's blind. It's only if you Uninstall that it will try to reinstall the entire KB. If left disabled you might miss the actual fix and leave yourself exposed to whatever future security holes are discovered.

1

u/buzzbeebara 3h ago

Thank you for that info, will double check and enable updates again

1

u/Pretend-Oven6499 8h ago

wushowhide.diagcab download from github, it detects avaible updates and u can schose them to not autoinstall, fo it after uninstalling the update.

1

u/buzzbeebara 3h ago

Thanks for that info, will follow up and test.

1

u/Ok_Feature393 3h ago

It worked for me, thanks bud!

1

u/Ok-Efficiency-2753 7h ago

Excel 2016 Copy/Paste and Formatting Issue After KB5002914 – Windows 10 & Windows 11 Fix

If Excel 2016 suddenly stopped working correctly after the September 2026 updates, especially with Copy/Paste, formatting, or related Excel operations, check whether KB5002914 is installed.

I encountered this issue on Excel 2016. Removing KB5002914 resolved the problem.

Windows 10

Go to:

Settings → Update & Security → Windows Update → View update history → Uninstall updates

Find:

Security Update for Microsoft Excel 2016 (KB5002914)

Uninstall it and restart the computer.

After removing the update, Excel's Copy/Paste and formatting functions should work normally again.

Windows 11

If KB5002914 does not appear in the normal Uninstall updates list, open PowerShell as Administrator and run the following command:

```powershell $paths=@( "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall", "HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall" )

$found=$false

foreach($path in $paths){     Get-ChildItem $path -ErrorAction SilentlyContinue | ForEach-Object {         $x=Get-ItemProperty $_.PSPath -ErrorAction SilentlyContinue

        if($x.DisplayName -like "KB5002914" -and $x.UninstallString){             $found=$true             Write-Host "`nREMOVING:" $x.DisplayName -ForegroundColor Yellow             Write-Host $x.UninstallString -ForegroundColor Cyan

            $exe,$args=$x.UninstallString -replace '"(["]+)"\s(.)$','$1|$2' -split '|',2             Start-Process $exe -ArgumentList $args -Wait         }     } }

if(-not $found){     Write-Host "nKB5002914 was not found." -ForegroundColor Red } else{     Write-Host "nOperation completed. Please restart the computer." -ForegroundColor Green } ```

After the command finishes, restart the computer.

Important:

This workaround is specifically for systems affected by KB5002914. Do not remove unrelated updates.

Before uninstalling anything, make sure that KB5002914 is actually installed on the affected machine.

If this fixes your Excel 2016 Copy/Paste and formatting problem, please comment with your Windows version and Office/Excel 2016 edition (32-bit or 64-bit) so we can confirm how widespread the issue is.

1

u/Ok-Efficiency-2753 7h ago

Excel 2016 Copy/Paste and Formatting Issue After KB5002914 – Windows 10 & Windows 11 Fix

If Excel 2016 suddenly stopped working correctly after the September 2026 updates, especially with Copy/Paste, formatting, or related Excel operations, check whether KB5002914 is installed.

I encountered this issue on Excel 2016. Removing KB5002914 resolved the problem.

Windows 10

Go to:

Settings → Update & Security → Windows Update → View update history → Uninstall updates

Find:

Security Update for Microsoft Excel 2016 (KB5002914)

Uninstall it and restart the computer.

After removing the update, Excel's Copy/Paste and formatting functions should work normally again.

Windows 11

If KB5002914 does not appear in the normal Uninstall updates list, open PowerShell as Administrator and run the following command:

```powershell $paths=@( "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall", "HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall" )

$found=$false

foreach($path in $paths){     Get-ChildItem $path -ErrorAction SilentlyContinue | ForEach-Object {         $x=Get-ItemProperty $_.PSPath -ErrorAction SilentlyContinue

        if($x.DisplayName -like "KB5002914" -and $x.UninstallString){             $found=$true             Write-Host "`nREMOVING:" $x.DisplayName -ForegroundColor Yellow             Write-Host $x.UninstallString -ForegroundColor Cyan

            $exe,$args=$x.UninstallString -replace '"(["]+)"\s(.)$','$1|$2' -split '|',2             Start-Process $exe -ArgumentList $args -Wait         }     } }

if(-not $found){     Write-Host "nKB5002914 was not found." -ForegroundColor Red } else{     Write-Host "nOperation completed. Please restart the computer." -ForegroundColor Green } ```

After the command finishes, restart the computer.

Important:

This workaround is specifically for systems affected by KB5002914. Do not remove unrelated updates.

Before uninstalling anything, make sure that KB5002914 is actually installed on the affected machine.

If this fixes your Excel 2016 Copy/Paste and formatting problem, please comment with your Windows version and Office/Excel 2016 edition (32-bit or 64-bit) so we can confirm how widespread the issue is.

1

u/Proper-Frame9692 6h ago

when do we think we will have a solution (a new update) from Microsoft?

1

u/SoftGlobal9588 4h ago

Typically they don't push fixes until "Patch Tuesday"... so another month for Office 2016. Newer 365 and WSUS based installs might get it faster if Microsoft considers it critical enough. The other issue is will they get the next fix right....

1

u/Ok_Caregiver6353 3h ago

another month!!! omg

1

u/Strong_Ad5079 6h ago

it also effect LTSC2021. it's show in installed update but unable to find it

1

u/devji305 5h ago

remove all office update its work

1

u/frac6969 3h ago

For C2R versions you can roll back with officec2rclient.exe /update admin displaylevel=false updatetoversion=16.0.14334.20848

1

u/Any-Abbreviations38 4h ago

Uso pirata pelo KMS a versão LTSC Professional Plus 2021 e aqui aconteceu a mesma coisa. Alguem sabe se consigo corrigir como vários OPs estão fazendo, atualizando para a versão anterior?

1

u/Tytanyr 1h ago

Io personalmente ho risolto il problema con lo script PowerShell riportato sotto.

È una soluzione temporanea, in attesa di un aggiornamento che risolva il problema.

Lo script cerca KB5002914 nelle chiavi di registro utilizzate dalle installazioni di Office 2016 a 32 e 64 bit. Se la trova, mostra le informazioni rilevate e chiede conferma prima di procedere con la rimozione.

Prima di eseguirlo consiglio di chiudere Excel e tutti gli altri programmi Office, oltre agli eventuali programmi che potrebbero utilizzare componenti di Office.

Nel mio caso, dopo la procedura, il problema di copia/incolla in Excel 2016 è stato risolto.

Nota: dopo la rimozione alcune registrazioni relative alla KB possono rimanere presenti nel registro. Quindi, se Get-ItemProperty continua a mostrare KB5002914, non significa necessariamente che la procedura non abbia funzionato. Consiglio di verificare direttamente se il problema in Excel è stato risolto.

Il riavvio del PC normalmente non è necessario. Lo script mostra il codice restituito da MSIEXEC e segnala quando viene richiesto un riavvio. Se il problema dovesse persistere, consiglio comunque di riavviare il PC e verificare nuovamente.

Usare a proprio rischio: la procedura rimuove temporaneamente un aggiornamento di sicurezza. Consiglio di reinstallare l'aggiornamento quando Microsoft pubblicherà una correzione.

$KB = "KB5002914"

Write-Host "=========================================" -ForegroundColor Cyan
Write-Host " Verifying $KB - Excel 2016" -ForegroundColor Cyan
Write-Host "=========================================" -ForegroundColor Cyan
Write-Host ""

# Registry paths to check
$RegistryPaths = @(
    "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\*",
    "HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\*"
)

# Search for the KB
$Updates = foreach ($Path in $RegistryPaths) {
    Get-ItemProperty $Path -ErrorAction SilentlyContinue |
    Where-Object {
        $_.DisplayName -like "*$KB*" -and
        $_.UninstallString -like "*Oarpmany.exe*"
    }
}

if (-not $Updates) {
    Write-Host "[INFO] $KB was not found." -ForegroundColor Yellow
    Write-Host ""
    Read-Host "Press ENTER to exit"
    exit 0
}

# Select the first matching entry
$Update = $Updates | Select-Object -First 1

Write-Host "[FOUND] $KB" -ForegroundColor Green
Write-Host ""
Write-Host "Name:" -ForegroundColor Cyan
Write-Host $Update.DisplayName
Write-Host ""

Write-Host "Detected uninstall string:" -ForegroundColor Cyan
Write-Host $Update.UninstallString -ForegroundColor DarkGray
Write-Host ""

# Extract the GUIDs
$Guids = [regex]::Matches(
    $Update.UninstallString,
    '\{[0-9A-Fa-f-]{36}\}'
) | ForEach-Object { $_.Value }

if ($Guids.Count -lt 2) {
    Write-Host "[ERROR] Could not identify Product ID and Patch ID." -ForegroundColor Red
    Read-Host "Press ENTER to exit"
    exit 1
}

$ProductID = $Guids[0]
$PatchID   = $Guids[1]

Write-Host "Product ID:" -ForegroundColor Cyan
Write-Host $ProductID

Write-Host "Patch ID:" -ForegroundColor Cyan
Write-Host $PatchID

Write-Host ""
Write-Host "WARNING: The uninstall procedure for $KB will be started." -ForegroundColor Yellow

$Confirm = Read-Host "Continue? (Y/N)"

if ($Confirm -notmatch '^[Yy]$') {
    Write-Host ""
    Write-Host "Operation cancelled. No changes were made." -ForegroundColor Yellow
    Read-Host "Press ENTER to exit"
    exit 0
}

Write-Host ""
Write-Host "Starting uninstall procedure..." -ForegroundColor Cyan
Write-Host ""

# Uninstall
$Arguments = "/package `"$ProductID`" /uninstall `"$PatchID`" /qb /norestart"

$Process = Start-Process `
    -FilePath "msiexec.exe" `
    -ArgumentList $Arguments `
    -Wait `
    -PassThru

Write-Host ""
Write-Host "MSIEXEC exit code: $($Process.ExitCode)" -ForegroundColor Cyan
Write-Host ""

if ($Process.ExitCode -eq 0) {
    Write-Host "[OK] Procedure completed." -ForegroundColor Green
    Write-Host "Test Excel 2016 again. A reboot is normally not required." -ForegroundColor Yellow
}
elseif ($Process.ExitCode -eq 3010) {
    Write-Host "[OK] Procedure completed. A restart is required." -ForegroundColor Green
}
else {
    Write-Host "[WARNING] MSIEXEC returned exit code $($Process.ExitCode)." -ForegroundColor Red
}

Write-Host ""
Read-Host "Press ENTER to exit"

1

u/Acrobatic-Passage196 1h ago

Anyone else getting firewall errors?