Forum Discussion
Duplicate Styles warning
akira_hirai Apparently one computer has a slightly newer build of Excel than the other, which seems to have newer functionality that checks for this styles issue. The message is caused by Excel detecting that you have many styles that have similar names, like this:
These extraneous styles have been pulled into your file by copying sheets and/or cells from other workbooks and pasting them into the current workbook. If you simply delete those styles, you indeed loose formatting if those styles have been used. The only way to address this is by cleaning up the list of styles manually and re-applying any lost formatting. Tedious, but something you might consider doing. I have a tool that allows deleting of styles that are not used anywhere in the file, that should leave your formatting intact. https://jkp-ads.com/productsremediation.asp
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.
