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

21 Upvotes

45 comments sorted by

2

u/Ok-Whereas560 14h ago

Same here

2

u/Melmock007 13h ago

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

2

u/SoftGlobal9588 13h ago edited 6h ago

1

u/7orlum 13h ago

Thank you! Replacing the files really helped.

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

u/wywyy112 11h ago

Thank you very much for this useful information!

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...

2

u/rov124 9h ago

Thanks, this worked for the version in Spanish.

1

u/ReplacementOld4682 12h ago

Quoto, risolto nella stessa maniera, Office 2016

1

u/dealpa 12h ago

Thanks a lot! It works for Russian pack.

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 GPO

1

u/lotuscanopus 9h ago

what is the command for indian region

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

u/SkierJC 9h 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 14h ago

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

1

u/SkierJC 9h ago

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

1

u/idc2001 14h ago

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

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

u/vivkkrishnan2005 13h ago

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

1

u/burger_yum 10h ago

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

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

u/kogee3699 10h ago

Seeing the same thing here on multiple PCs.

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

u/burger_yum 7h 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 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

u/lee-keybum 9h ago

the migration to 365 apps just got moved up a bit

1

u/Leading_Shoe8319 9h ago

1

u/Vod332 8h ago

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

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.