Why does this keep happening?
Short answers.
Each guide explains the cause first, then every reasonable fix, including the ones built into Excel, PowerPoint, Windows, macOS and iPhone. The matching UnjamKit tool comes last.
All guides
- Why Excel Removes Leading Zeros From a CSV (and How to Keep Them)
A CSV stores 00123 correctly; Excel drops the zeros when it opens the file. Four ways to keep leading zeros and long IDs, and why Save As cannot bring them back.
- What Is a HEIC File? Why It Won’t Open and How to Convert It
HEIC is the photo format iPhones use by default. Why Windows, forms and portals reject it, how to convert HEIC to JPG on iPhone, Mac, Windows or in a browser, and what you lose.
- How to Compress an Image to 200 KB (or 100 KB) for an Online Form
Why phone photos are too big for online forms, what a 200 KB limit really means, and how to get under it on Windows, Mac or in the browser without ruining the photo.
- How to Compress a PDF for an Upload Portal With a Size Limit
Why scanned PDFs are so large, how to get under a 1 MB or 2 MB upload limit, which DPI to choose, and when splitting or optimizing is better than re-rendering pages.
- How to Compare Speaker Notes Between Two PowerPoint Versions
PowerPoint has no view that lists only changed speaker notes. Three ways to compare notes between two PPTX versions, including when slides were moved or inserted.
- How to Rename Files From an Excel List (Old Name to New Name)
Have a spreadsheet of current and new file names? Four ways to rename many files from an Excel list: PowerShell, a cmd batch file, Mac Terminal, or a browser tool that checks every name first.
Last updated