Forum Discussion
Abnormal file size caused by converting Excel tables to data areas
With permission of all, I would offer an additional solution.
This is how you could reduce the volume of your Excel file again:
To be on the safe side, make a backup of the file first.
Try to delete the superfluous cells by marking the rows or columns,
right-clicking with the mouse and selecting Delete rows.
Quickly delete multiple cells/columns:
select/click cell/column,
CTRL+left shift key+ right or down arrow
depending on the cell or column, press .
Save the file. Close and open again. If you look at the file size in Explorer, it should now be significantly reduced and the table should be usable again.
If the size doesn't really change afterwards, try copying the spreadsheet to a new file and saving it accordingly. At least that should help.
Happy new year and much success with Excel.