Trim The Size Of Inflated Spreadsheets


Q. A lot of my spreadsheets contain macros, which, of course, fatten the files. But when I delete the macros, the files don’t shrink back to their original size. That not only makes for very sluggish Internet transmissions but also stuffs my hard drive. Is there some way to return the spreadsheet to svelte size?

A. Microsoft is routinely criticized for writing bloated software code and for designing files that just seem to grow fat as they age. Here are two solutions that often work, but don’t be surprised if they fail.

After removing excess data from a file or deleting the macros, reopen the file and save it, using File , Save As , under a different name. If the file has shrunk, delete the fat, old file and rename the slimmed-down one with the original name. If that doesn’t work, try this: Copy each individual worksheet to a new workbook.

If you have the problem in Word, check to see whether there are any graphics in the document. Some graphics, because of their formatting, are just naturally fat. It’s not hard to change their formatting to one that’s much leaner. Instead of just copying a graphic into a document with Paste (Ctrl+V), use the toolbar’s Insert command ( Insert , Picture , From File ). That way, Word automatically converts any graphic to the JPEG format, which provides good resolution without bloat.

If those methods fail, I’m sorry to say your only recourse may be to write a letter of complaint to Microsoft. Enough complaints might produce some remedial action.


How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.


In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.