Forum Discussion
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
There's a way but it's more of last resort. Re-name the file to end with the extension .zip. Open the zip using File Explorer. Open the 'xl' folder and delete styles.xml. Close out of the zip package and re-name the file to be an .xlsx again. When the file is opened, you'll receive a message indicating problems with content were found (similar to an open and repair) and styles will be wiped.
Thank you very much for your answer. After experiments, the size of the file is not reduced. Maybe my description of the problem is not accurate enough