April 03, 2006

Power Spreadsheets



When you take the time to write AUTO_OPEN and AUTO_CLOSE macros so as to clear out table contents upon file closing, and reload them when you open the file to get the file size down under 5 Meg, you are entering the world of Power User in terms of Excel / spreadsheets.

I just finished up a big revision of a large, complex, and macro-laden spreadsheet for a client, and I am mucha happy to have it off my "to do" list and be able to invoice for it!

1 comment:

Anonymous said...

Hey, tell me more about this. Is it a utility I can access, or is it smething you wrote? I have occasionally unwieldy sheets that could use some help.

KC