Forum Discussion
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...
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!
- Well, I've reinstalled Office 365 and the problem still persists on this specific computer. But I can't reproduce the issue on any other computer. I guess I'll chalk it up to the fact that this computer is over 6.5 years old.