Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

DisableCopyUnusedCustomStyles Not working when Excel running in separate instance

Here is a link to an issue i opened in Excel Power users.

https://social.technet.microsoft.com/Forums/windows/en-US/710c7bae-eb24-4bf5-93dc-ceb453678a76/disablecopyunusedcustomstyles-not-working?forum=excel

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.

2 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Rick Noltemy shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • lionel berton commented  ·   ·  Flag as inappropriate

    I have exactly the same problem and I don't see any solution except cleaning the styles each time.

Feedback and Knowledge Base