Forum Discussion

akira_hirai's avatar
akira_hirai
Copper Contributor
Sep 02, 2024

Duplicate Styles warning

I'm using Office 365. A large spreadsheet I use almost daily recently started displaying the following warning when I open it. (The warning reads: "DUPLICATE STYLES  This workbook has many du...
excel
office 365
akira_hirai's avatar
akira_hirai
Copper Contributor
Sep 03, 2024

JKPieterse Thanks for the response!

 

I checked the build on both computers and they are the same: "Version 2408 Build 17928.20114".

 

When I paste anything into the spreadsheet, I always Paste Special as values or as formulas, so no new styles are being introduced.

 

The spreadsheet has the same 8 custom cell styles that it has always had, and the styles have very distinct names.

 

Since this is just a warning rather than an error, is there a way to suppress the warning? Maybe by making a registry edit?

 

Thanks!

 

P.S. - I downloaded the trial version of your Add In product but when I tried to open it, Excel said "This file type is not supported in Protected View."

JKPieterse's avatar
JKPieterse
Silver Contributor
Sep 05, 2024

akira_hirai Can you show a screen-shot of your styles dialog for the file in question?

If it is as you describe, click Help, Feedback, I don't like something and tell Microsoft what you think is wrong.

About my add-in not loading: you have to first unblock the file as described here: https://jkp-ads.com/articles/excel-add-ins-fail-to-load.asp