This project is read-only.

RemoveStyles.xlam for Excel 2007 and newer

Rating:        Based on 8 ratings
Reviewed:  8 reviews
Downloads: 83302
Released: Mar 29, 2013
Updated: Jun 25, 2014 by AKeeler
Dev status: Stable Help Icon

Recommended Download

Application RemoveStyles.xlam
application, 17K, uploaded Jun 25, 2014 - 83302 downloads

Release Notes

RemoveStyles.xlam is an Excel add-in to remove all custom styles in an Excel workbook. It will also give you a count of the styles in the Active Workbook.

Reviews for this release

Really nice code! It helped me to fix a damaged file very quickly, by removing lots of weird styles. Thanks a lot!.
by slg000 on Mar 9, 2016 at 4:32 PM
I had a sheet that somehow inherited styles from spreadsheets going back to 1993 (i'm not joking). My own attempt to code was not picking up many of them ... I had used a For/Each Loop. I ran the macro in edited form and styles appeared top still be there. So I restarted Excel and re-opened the spreadsheet. Between my code and this I was left with the just two native Excel styles. I could not be happier!
by BoasWhip on Oct 7, 2015 at 10:36 AM
I noticed a file that suddenly had so many duplicate styles that I was deleting one by one. After finding this download and running, I discovered there were over 40,000 styles in my box! This add-in is amazing! It deleted them all in seconds! This is a keeper for sure!
by VRobbins on Sep 25, 2015 at 12:46 AM
A-mazing. Allowed me to resolve excruciatingly painful Smart View Performance Issues with Oracle Hyperion Essbase that were taking FOREVER to process due to Excel cell styles. Thank you so much for the macro!
by mdjvdez on Sep 12, 2014 at 8:12 PM
Works like a charm in Excel 2010. Thank You!
by GregSalts on Jul 31, 2014 at 8:22 PM
half the time failed when launch Excel 2010. It's getting "Object variable or With block variable not set" error. It works well when it doesn't have this error.
by wbzhe1 on Jun 12, 2014 at 12:37 AM
Thanks you !!!
by Chamnan2k on Jul 30, 2013 at 9:32 AM

by ryo_haduki on Feb 29, 2012 at 12:37 PM