Why is the Excel file not reduced?
Select View details on any current MS Office or PDF file in NXPowerLite, to see a size audit of the content inside and what might be preventing further reduction.
In this example, the main size is in Worksheets and Pivot table cache. Once you know what content is not being compressed, you can address it using the help links below.
What content is still large?
Content is organized by size, with the largest items listed first. The number of items are indicated in parenthesis, for example, Worksheets (8) = eight worksheets.
Pivot table cache
If your pivotCache folder is very large, then follow these instructions to clear the pivot table cache.
Embedded objects
Read here for how to compress embedded objects in Excel.
External Links
Learn how to break links to reduce file size.
Worksheets
If the worksheets contain lots of data then see how to save in the XLSB format to reduce size.
Other
If this category is very large, you can use 7-zip to look inside the file and see what is big.
Don’t see view details?
If you don’t see the View details feature in your version of NXPowerLite, you probably need to update to NXPowerLite Desktop 11.
One final thing to check…
Sizes are listed in KB in NXPowerLite, anything below 1,000 KB (1 MB) is reasonably small and should be easily transferred by email. Most email limits have risen to > 5 - 10 MB even in restricted scenarios, although there are still some areas where the limits are much tighter.
Should we make an Excel Add-in to help with this?
Please can you let us know if you’d be interested in an Excel add-in that made finding embedded objects and other media in your Excel files super easy. We have already built something similar for PowerPoint called Slidewise, and we’d love to know if a similar tool for Excel would be useful.
It might look something like this — as you can see it would also show you the size of images and other resources in your spreadsheet.
Register interest
If you’d be excited to add Sheetwise to your toolbox - please can you share your email with us to let us know. If you do we’ll also keep you notified of any progress.