Office 2016 pro plus - XL copy paste is not functioning (no issue with MS Word)

Hey everyone,

Like many of you, our organization ran into the Excel copy/paste and Format Painter failure caused by the September security update (KB5002914). Since corporate policy completely blocks us from rolling back security patches, we built a zero-clipboard VBA workaround that completely bypasses the broken metadata pipeline.

It successfully copies values, cell formulas, visual formatting, and column widths without relying on the broken Windows clipboard object.

I’ve uploaded the clean VBA code along with a Group Policy (GPO) file-copy and registry configuration guide to GitHub Gists so you can drop it seamlessly into your enterprise environment via an .xlam Add-in:

🔗 [https://gist.github.com/GTBStrong/53d6d1233ff1e408f6c760af9502deec]

What the GPO Deployment does:

1. Silently pushes the .xlam file to the users' local AppData roaming directory.
2. Automates the Excel OPEN registry keys so the macro loads silently for every user on startup across all existing spreadsheets.

Hopefully, this saves some teams a massive headache while we wait for an official Microsoft hotfix!

P.S.  Initial tests for me included one larger workbook that caused the function to return a 1004 error.  I've isolated the behavior to that one particular workbook so far.  Either something about the size or the contents that is tripping up the rangeClass method.  As always ymmv.  😁