Posts Tagged ‘File format’

Reduce file size and load/save time with .xlsb format

Written by Peter Albert on . Posted in Starter

Executive Summary

Store any Excel 2007+ files as Excel Binary Workbook (.xlsb), instead of the default Excel Workbook or Excel Macro-Enabled Workbook! This will reduce the size of the file significantly (usually by 30-60%!) and with it the load/save time.

To make this the default format, use OptionsSaveSave file in this format and change the dropdown to “Excel Binary Format“.

Detailed description