A 200-Row Spreadsheet That Weighed 16 MB and Froze Every Time She Inserted a Row
Today's house call was a business one: a local distributor whose entire price list lives in one Excel file. Lately it had started opening slower and slower, and inserting a row — the most basic thing you do to a price list — froze the whole computer. Every time.
Here is the part that makes this worth writing up: the spreadsheet held about 200 rows of prices. The file was 16 megabytes. That is like a single-page letter that somehow weighs as much as a phone book, and it is almost never a corrupt file or a dying computer. It is something sneakier.
71,315 invisible passengers
When I opened the file up properly, the count came back: 71,315 hidden objects living inside the sheet. Invisible shapes, empty text boxes, leftover picture frames — none of them visible, none of them wanted, all of them real.
Where do they come from? Copy and paste. When you copy prices from a website, a PDF, or an email and paste them straight into Excel, the paste quietly brings along whatever else was under the selection: formatting containers, web layout objects, invisible drawing shapes. One paste might drop in a handful. Do that for years, a few pastes a week, and you are sitting on tens of thousands of them without ever seeing a single one.
And the row-insert freeze? That was the giveaway. Every time she inserted a row, Excel had to stop and recalculate the position of all 71,315 objects anchored to the cells below. Two hundred rows of data, seventy-one thousand invisible things to shuffle. Of course it froze.
The fix: 16 MB down to 19 KB
First rule of the bench: a protected backup of the original before anything gets touched. Her data was never at risk.
Then I rebuilt a clean copy of the price list — every row, every price, the formatting and column widths intact — with all 71,315 stowaways left behind. The result: the same price list, 19 kilobytes instead of 16 megabytes. It opens instantly. Rows insert with zero hesitation. Same data, about 800 times smaller.
How to keep it from coming back
One habit fixes this forever: when you copy prices (or anything) from a website, PDF, or email, do not paste straight in. Use Paste Special → Values — right-click where you want it and choose the little clipboard icon marked “123”. That pastes the words and numbers and strips everything else. The old-school version works too: paste into Notepad first, then copy from Notepad into Excel. Either way, the invisible passengers never board.
The second finding: a computer running out of breathing room
While I was in there I checked why everything else felt sluggish too. The machine runs QuickBooks, Outlook, Excel, and about thirty browser tabs at once — a completely normal small-business workload — on 8 GB of memory. It was overflowing to disk constantly, which slows every program at once, not just Excel.
The honest recommendation: a memory upgrade to 16 GB, the most this machine supports. It is an inexpensive part and about fifteen minutes of work, and it is the single biggest speed improvement available for this computer — it ends the overflow across QuickBooks, Excel, and the browser all at once. That is scheduled as a follow-up visit, priced upfront like everything else.
If your business runs on a spreadsheet that has gotten slow
A price list, a customer list, a job tracker — if a file your business depends on has started crawling or freezing, and it never used to, there is a real, findable reason. It is usually not “you need a new computer.” I come to local businesses around Woodstock and Cherokee County, diagnose it for free, and you approve the fix before anything happens. Call or text, and bring the spreadsheet.