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
This is content we haven’t yet categorised. If Other is very large, follow the instructions below to use BetterZip to see what content is causing the problem.
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.
Use BetterZip to look inside XLSX files
We’ve taken a look at many archive apps for macOS and have found a free Quick Look extension that enables you to see the breakdown of the content within an Excel file. To prepare your macOS for seeing your XLSX content, follow our easy 3-step guide to installing the BetterZip Quick Look extension.
Once BetterZip Quick Look extension is working take a copy of your XLSX file and rename the file adding ‘.zip’. Now select the file in Finder and press the spacebar to start Quick Look.
You will see a folder treeview, where you can browse through the folders to see where the large content is lurking. The folders are named for the content they contain and should be pretty clear.
