This is the Trace Id: 55ced5c71eb1795f8c5ae35c1f9e90c3
Skip to main content Microsoft 365 Office Azure Copilot Windows Surface XBOX Support Windows Apps OneDrive Outlook Moving from Skype to Teams OneNote Microsoft Teams Accessories XBOX Game Pass Ultimate XBOX games PC games Microsoft AI Microsoft Security Azure Dynamics 365 Microsoft 365 for business Microsoft Power Platform Windows 365 Digital Sovereignty Microsoft Developer Microsoft Learn Support for AI marketplace apps Microsoft Tech Community Microsoft Marketplace Software companies Visual Studio Free downloads & security Education Gift Cards View Sitemap

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:

    1.0

    Date Published:

    7/15/2024

    File Name:

    Workbook Size Optimizer_x86_windows_8_server_2012.msi

    Workbook Size Optimizer_amd64_windows_8_server_2012.msi

    Workbook Size Optimizer_amd64_Windows_7_Server_2008_and_below.msi

    Workbook Size Optimizer_x86_Windows_7_Server_2008_and_below.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