No. of Recommendations: 7
I think I've found a solution to the growing spreadsheet problem. The Excel programming community highly recommends Rob Bovey's free Excel Code Cleaner. It's quick to download and has its own install/uninstall programs. After you install it, the Tool Menu has an entry called "Clean Project." I recommend that people install this and clean the code whenever the spreadsheet startes to grow large. Get it here:

http://www.appspro.com/utilities/Cleaner.asp

For those wondering what in the world I'm talking about, every version of the options tracking spreadsheet has had a problem with the file growing larger every time the macro is run. Excel takes longer and longer to open and save the file until eventually it refuses to run. I've tamed some of this behavior, but the latest versions of the macro still grow 1024 bytes every time.
Print the post  

Announcements

What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.