DisableCopyUnusedCustomStyles Not working when Excel running in separate instance
Here is a link to an issue i opened in Excel Power users.
Basically, when you copy a single cell from a workbook that contains x number of custom styles, all of the styles copy into the other workbook. All of them.
there is a registry entry called DisableCopyUnusedCustomStyles that can be added to HKCU\Software\Microsoft\Office\excel\xx.0\Options that will prevent this behavior....but only when running in the same EXE instance.
But running in separate EXE instances and doing a copy of a cell from a workbook with many custom styles, into a brand new workbook copies all of the style. We have workbooks with 60k+ styles anymore in our firm. Hundreds of them.
Would like to see if someone can fix it so the registry entry works across separate EXE instance also.
lionel berton commented
I have exactly the same problem and I don't see any solution except cleaning the styles each time.