XSFormatCleaner.xla

Rating:        Based on 3 ratings
Reviewed:  3 reviews
Downloads: 42911
Released: Aug 14, 2013
Updated: Aug 14, 2013 by AKeeler
Dev status: Stable Help Icon

Recommended Download

Application XSFormatCleaner.xla
application, 49K, uploaded Aug 9, 2013 - 42437 downloads

Other Available Downloads

Application XSFormatCleaner.xla
application, 44K, uploaded Aug 14, 2013 - 474 downloads

Release Notes

Modified the commandbar code to use CommandBar IDs instead of English names.

Reviews for this release

     
It did not delete excessive rows but I found a way that did: http://computertrainer.wordpress.com/2009/07/28/permanently-remove-empty-rowscolumns-at-the-end-of-an-excel-spreadsheet/
by ao266 on Mar 11 at 11:28 AM
     
I'm not sure what went wrong for CBen, but this marco has been wonderful. First, it tells you that you have to save your document before the changes become permanent. So I'm not sure why you couldn't just "undo" what happened before. I mainly use this when I get excel errors that turn 20 kb sized files int 40 mb sized files for no reason. I have no idea why this error happens, and I can't seem to manually fix it with the clear all command, but this does the trick. I wish I could read the code to see what commands the macro is running, but I am not that advanced. This file works perfectly at reducing formats. I haven't tried it, but I have some excel documents that have been rolled forward year after year and the styles are reaching their limit, I'm hoping this macro can fix that problem too. Only complaint(s) (reason it didn't get five stars): 1. On some large files it times out or takes so long that I can't sit and wait for it to finish. 2. To fix issues with 1, it would be nice if it was possible to add a feature or another macro that only works on selected cells, since this marco goes worksheet to worksheet. Otherwise great tool and thank you!
by Michael95621 on Jan 22 at 4:32 PM
     
Used on a large spread sheet that had last cell issues. Hilighted only excess cells. All data and formats removed - will need to dig out the back-up copy now.
by CBen on Jan 6 at 12:37 PM