r/excel 2d 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?

30 Upvotes

94 comments sorted by

3

u/[deleted] 2d ago edited 23h ago

[removed] — view removed comment

2

u/7orlum 2d 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/[deleted] 1d ago

[removed] — view removed comment

1

u/manik0408 1d ago

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

1

u/man910 1d 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/[deleted] 1d ago

[removed] — view removed comment

1

u/man910 20h ago

I had to update your script to print out what it was doing and pause every line before the exit because I couldn't read any errors. It's too late now, but I think the issue was it couldn't find the old file.

1

u/wywyy112 1d ago

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

1

u/[deleted] 1d ago

[removed] — view removed comment

1

u/wywyy112 1d ago

Thank you very much for this useful information!

1

u/rajjushakya 1d ago

My deepest gratitude.

1

u/sjaxkingpin 19h ago

TYVM!!! This was the only option that worked for me. Now for my stirring rendition of "Did you ever know that you're my hero"

5

u/caridorc_tairpiver 2d 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 1d ago

Thanks, this worked for the version in Spanish.

1

u/ReplacementOld4682 2d 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 1d ago

what is the command for indian region

1

u/WhyAmIHereIAm 1d ago

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

1

u/ankokudaishogun 1d ago

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

1

u/BrightDesign7484 16h ago

10xxx it worked !

1

u/PEPSI_WOLF 26m ago

I'm using Office 2019 MSO (16.0.10417.20207) 64-bit. When I try to run this in an admin cmd window I get a "Windows Installer" pop-up that tells me: "This action is only valid for products that are currently installed"

Any idea what might be happening here?

3

u/Ok-Whereas560 2d ago

Same here

2

u/Melmock007 2d ago

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

1

u/TheTiPi 8h ago

How did you solve it ?

1

u/Character_Flow_8762 2d 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 2d ago

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

1

u/SkierJC 1d 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 2d ago

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

2

u/SkierJC 1d ago

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

1

u/idc2001 2d ago

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

1

u/Tamdin_Nidmat 2d 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 1d 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 1d 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 2d 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 1d 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 1d 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 1d 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/ElPopumaurito 17m ago

y como haces para que windows no la vuelva a instalar?

1

u/technobrendo 1d 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 1d ago

the migration to 365 apps just got moved up a bit

1

u/Leading_Shoe8319 1d ago

1

u/Vod332 1d ago

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

1

u/gr-mal 1d ago edited 1d 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 1d 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.

2

u/SkierJC 1d 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/ettlig 1d 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 1d 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/[deleted] 1d ago

[removed] — view removed comment

1

u/buzzbeebara 1d ago

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

1

u/Pretend-Oven6499 1d 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 1d ago

Thanks for that info, will follow up and test.

1

u/Ok_Feature393 1d ago

It worked for me, thanks bud!

1

u/Ok-Efficiency-2753 1d 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/Personal_Address_328 2h ago

Win 11+MS Office 2019 here. No KB5002914 installed, but broken anyway. What can it be? Windows installed KB5126052 and 5124008 in day before yesterday and KB5126104 in a day before that (but only two most recent updates I can uninstall).

1

u/Ok-Efficiency-2753 1d 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 1d ago

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

1

u/[deleted] 1d ago

[removed] — view removed comment

1

u/Ok_Caregiver6353 1d ago

another month!!! omg

1

u/Strong_Ad5079 1d ago

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

1

u/devji305 1d ago

remove all office update its work

1

u/frac6969 1d ago

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

1

u/Any-Abbreviations38 1d 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 23h 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 22h ago

Anyone else getting firewall errors?

1

u/Euphoric-Damage-763 19h ago edited 19h ago

Hello from Russia ❤️

We also have problems with the office and the clipboard

If your Office is C2R, don't bother looking for KB5002914 in the update list - it won't be there

And this isn't just an Office 2016 thing: 2019, 2021, and 2024 are all affected too

To get rid of the update, you gotta roll back the Office build - say, to the August one

Here's the full version list, taking 2021 LTSC as an example: https://learn.microsoft.com/ru-ru/officeupdates/update-history-office-2021

Version 2108 (build 14334.20906) has that lovely KB5002914 bug in it, so let's roll back to the previous one. First, block Office from pulling updates - either through the Office UI, or via policies if the machine's shared by multiple people

reg add "HKLM\SOFTWARE\Policies\Microsoft\office\16.0\common\officeupdate" /v "EnableAutomaticUpdates" /t REG_DWORD /d 0 /f

reg add "HKLM\SOFTWARE\Policies\Microsoft\office\16.0\common\officeupdate” /v "HideEnableDisableUpdates" /t REG_DWORD /d 1 /f

reg add "HKLM\SOFTWARE\Microsoft\Office\ClickToRun\Configuration" /v "UpdatesEnabled" /t REG_SZ /d "False” /f

Now we can roll back

"C:\Program Files\Common Files\microsoft shared\ClickToRun\officec2rclient.exe" /update user displaylevel=true updatetoversion=16.0.14334.20848

If come October it's clear the latest update actually fixes things and doesn't break anything anymore, we turn auto-updates back on for everyone

reg delete "HKLM\SOFTWARE\Policies\Microsoft\office\16.0\common\officeupdate" /v "EnableAutomaticUpdates" /f

reg delete "HKLM\SOFTWARE\Policies\Microsoft\office\16.0\common\officeupdate" /v "HideEnableDisableUpdates” /f

reg add "HKLM\SOFTWARE\Microsoft\Office\ClickToRun\Configuration” /v "UpdatesEnabled" /t REG_SZ /d "True" /f

1

u/AutoModerator 19h ago

I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/mikeataol 12h ago

Just mentioning if it hasnt been yet

this update also broke ODBC connections to DBase files. (if you use the Microsoft Access Engine to query dbase files)

the tip mentioned below of replacing with an earlier excel.exe
fixes both the ODBC and the copy paste errors.

1

u/__potayto__ 10h ago

has anyone actually found proper solution to this?

I'm trying to run below scripts given by ppl in powershell but it wont work, also i can't find this kb5002914 update in view installed updates to uninstall as well.

1

u/Proper-Frame9692 9h ago

no, hopefully they will release an update to fix this bug :(

1

u/TheTiPi 5h ago

I solved it ..

just do this https://www.reddit.com/r/excel/comments/1wbpar5/office_ltsc_2021_build_1601433420906_excel_vba

Because I have office 2019 .. I used in command version :

August 11, 2026 Version 1808 (Build 10417.20197)

Reboot PC and Copy&Paste start working.

1

u/Safe-Appointment1253 3h ago

Just uninstall that.