Trace Id is missing

Maximize the everyday with Microsoft 365

Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

Workbook Size Optimizer

The workbook size optimizer inspects the composition of the data model within your PowerPivot or PowerView enabled workbook, sees if the data in it can take less space and if possible, enables better compression.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:


    Date Published:


    File Name:

    Workbook Size Optimizer_amd64_Windows_7_Server_2008_and_below.msi

    Workbook Size Optimizer_amd64_windows_8_server_2012.msi

    Workbook Size Optimizer_x86_Windows_7_Server_2008_and_below.msi

    Workbook Size Optimizer_x86_windows_8_server_2012.msi

    EULA - MS Workbook Size Optimizer.docx

    File Size:

    3.2 MB

    3.2 MB

    3.2 MB

    3.2 MB

    41.2 KB

    The Workbook Size optimizer for Excel can better compress data inside workbooks that use PowerPivot or PowerView if this data comes from external data sources. The best size compression can be achieved for workbooks based on SQL Server databases and there are a few tricks we can do for other SQL datasources as well. The optimizer will install as an add in to excel and will provide you with a nice wizard to better compress the size of your workbook. Using the optimizer you can often get more than 1,000,000 rows datasets in a workbook under 10 MB, share it in SharePointOnline and interact withit using the Excel Web App in any browser.
  • Supported Operating Systems

    Windows 7, Windows 8 Pro, Windows Server 2008 Service Pack 2, Windows Server 2012

    Windows 7,8 Server 2008 or Server 2012 Excel 2013 32bit or 64 bit version
  • install and launch from Excel 2013
Follow Microsoft