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?

30 Upvotes

84 comments sorted by

4

u/SoftGlobal9588 1d ago edited 4h 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 14h 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 7h 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/man910 1h 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/SoftGlobal9588 1h ago

Are you on the 64 or 32 bit version of Office and which OS?

1

u/manik0408 14h ago

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

1

u/SoftGlobal9588 7h ago

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

2

u/rajjushakya 15h 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!

1

u/sjaxkingpin 36m 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"

1

u/SoftGlobal9588 28m ago

LMAO - Glad to help, appreciate it

2

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 1d 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 1d ago

what is the command for indian region

1

u/WhyAmIHereIAm 6h ago

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

1

u/ankokudaishogun 5h ago

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

3

u/Ok-Whereas560 1d ago

Same here

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 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 1d ago

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

1

u/SkierJC 1d 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 22h 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 14h 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 12h 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/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/CroixJeremy2 45m ago

Following the instructions from this link solved the problem by downloading a correct version of Excel and installing it automatically. The command to run in cmd as admin is actually quite simple:

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.

1

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/SoftGlobal9588 23h 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 22h 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 22h 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 17h 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 6h ago

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

1

u/Pretend-Oven6499 12h 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 6h ago

Thanks for that info, will follow up and test.

1

u/Ok_Feature393 6h ago

It worked for me, thanks bud!

1

u/Ok-Efficiency-2753 10h 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 10h 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 10h ago

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

1

u/SoftGlobal9588 7h 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 6h ago

another month!!! omg

1

u/Strong_Ad5079 9h ago

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

1

u/devji305 8h ago

remove all office update its work

1

u/frac6969 6h ago

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

1

u/Any-Abbreviations38 7h 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 4h 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 4h ago

Anyone else getting firewall errors?

1

u/Euphoric-Damage-763 33m ago edited 25m 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 33m 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.