Multiple Format Issue Crashing Files
Since Excel 2007 can only store a limited amount of formats, I continuously
have issues where my big files crash. I've found that this issue is due to a
massive amount of Cell Styles that get created everytime I copy/paste between
2 instances of excel (ie: using multiple monitors) or when I copy in a tab
from another file.
My question is, how can I delete all these Cell Styles at once? I can
select them one by one from the Cell Style drop down in the Home menu under
Styles. This is unmanageable when there are thousands of these.
|