Trim The Size Of Inflated Spreadsheets

BY STANLEY ZAROWIN

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.

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out