Forum Discussion
Wxy-Excel
Dec 27, 2022Copper Contributor
Abnormal file size caused by converting Excel tables to data areas
Abnormal.xlsx file size caused by converting Excel tables to data areas (empty areas with no data but occupied by styles). Is there a way to clear styles without opening the file
SergeiBaklan
Dec 29, 2022Diamond Contributor
If on Pro: Inquire -> Clean Excess Cell Formatting
If on 365: open in Excel for Web -> Check Performance -> Optimize
Or on any version select unused area, Home -> Clear -> Clear All