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