Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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.

• 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.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
EULA - MS Workbook Size Optimizer.docx SHA1: 0662eaaa7f40f2e3eee7a3682909d746886fbd67	34 KB
Workbook Size Optimizer_amd64_Windows_7_Server_2008_and_below.msi SHA1: 57ab17dc7ee9d63e6b5166a4ea1a941d4005faaf	2.84 MB
Workbook Size Optimizer_amd64_windows_8_server_2012.msi SHA1: b9da7ff348fe61ae9d15544f62c4cb6388839cd7	2.84 MB
Workbook Size Optimizer_x86_Windows_7_Server_2008_and_below.msi SHA1: 32dc0fcbbb8a10a52e97c247335af812b0daef12	2.83 MB
Workbook Size Optimizer_x86_windows_8_server_2012.msi SHA1: 1f73a518c0c644b998824bff26dde0355c8d2474	2.83 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Windows 7,8 Server 2008 or Server 2012Excel 2013 32bit or 64 bit version

• install and launch from Excel 2013