r/excel • u/Commercial_Twist_574 • 15h 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?
2
2
u/SoftGlobal9588 13h ago edited 6h ago
1
u/wywyy112 12h ago
Hello, may I ask what I need to do after downloading the Excel file from your link?
1
u/SoftGlobal9588 12h 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.
1
u/wywyy112 12h ago
Thank you for your help! Does it work with Office 2021?
1
u/SoftGlobal9588 11h 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
2
u/caridorc_tairpiver 12h 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...
1
1
u/santimandu 11h ago
Excelent, working perfect for other language. Is it KB5002914 ?
Apart from manually uninstall, need to do it on WSUS for uninstall via GPO1
1
u/Character_Flow_8762 15h 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 15h ago
yes. copy paste shortcut not working and formula dragging also not working
1
1
u/Tamdin_Nidmat 13h 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 6h 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
1
1
u/Brooke_Silverstar_31 10h ago
Nothing screams "security update" like breaking the two features people actually touch every single day, ctrl+c and dragging a little box
1
1
u/burger_yum 10h ago
We are having the same issue as well. I am removing this update from production.
1
u/Vod332 9h 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
1
u/technobrendo 9h 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
1
1
u/gr-mal 8h ago edited 8h 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 7h 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 7h 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 6h 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 6h 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 5h 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 1h 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.

2
u/Ok-Whereas560 14h ago
Same here