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.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:

    Workbook Size Optimizer_amd64_windows_8_server_2012.msi

    EULA - MS Workbook Size Optimizer.docx

    Workbook Size Optimizer_amd64_Windows_7_Server_2008_and_below.msi

    Workbook Size Optimizer_x86_Windows_7_Server_2008_and_below.msi

    Workbook Size Optimizer_x86_windows_8_server_2012.msi

    Date Published:


    File Size:

    3.2 MB

    42 KB

    3.2 MB

    3.2 MB

    3.2 MB

      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 System

    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 Instructions
      install and launch from Excel 2013