Forum Discussion
Duplicate Styles warning
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."
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
JKPieterse Here's the cell styles dialog, with the style names blocked out. As you can see, I only have eight custom styles. They all have very distinct and descriptive names.
I've opened the file on five computers other than my own and none of the other computers displayed the warning, so I'm sure it's a problem with my computer and not with my file. When I have time over the weekend, I plan to re-install Office 365 to see if that resolves the issue.
akira_hirai That definitely sounds like a false positive. If you dismiss that yellow bar using the close box on its right, and you click Review, Workbook performance, does it highlight the duplicate styles 'issue' as well?
- The Workbook Performance tool identified a few empty cells with number formats and text properties, many of which I optimized the last time I used the tool, but it does not identify the duplicate styles issue. I'll report back after reinstalling Office in a few days. Thanks for your assistance thus far!
