Excel files are sometimes large, accidentally bloated and you want to shrink the file size.
There is a brand new Excel Online feature coming to Desktop soon called Check performance which reduces size from the most common culprit formatting on unused cells.
I go through this method and alternatives for those without that feature, on the Inquire tab, how to check it and manually remove it
Example files can be found here: www.xlconsulting-asia.com/youtube-files
I also look at what else might make a file big, how to extract Excel sheet by sheet to check which worksheet is the culprit or how to export as a zip file to check other aspects
00:00 - Introduction
01:14 - Open online & file size
01:45 - Check performance NEW
03:11 - Recover if it goes wrong
03:37 - Check performance deep dive
05:04 - Inquire
06:15 - Delete all next manually
06:50 - Workbook statistics
07:16 - Other reasons for bloated files
07:42 - Change format to zip to explore
08:31 - Sort worksheets by size with Save as web
Источник: rutube.ru