This forgotten Excel format made my giant spreadsheet half the size
Working with huge Excel workbooks can be incredibly frustrating, especially when they become slow to open, save, and share with colleagues. After struggling to upload massive files to platforms like SharePoint or dealing with constant lag, you might even start to think that this is simply the price of working with large amounts of data. Well, it isn’t. An easy fix is to save your file as an Excel Binary Workbook (.xlsb) instead of the standard .xlsx format. At least, that’s what I now tend to do, and it’s given me the biggest performance boost I’ve seen with even my most demanding spreadsheets. Related I stopped wasting time in Excel when I learned these 3 functions Small formulas, big time savings. A better format for big files It looks like just another save option, but it stores your workbook very differently Screenshot by Ada .xlsb, short for Excel Binary Workbook, is what I use to halve the size of my spreadsheets. Chances are you’ve never clicked on it in Excel’s Save As dropdown, and that’s …









