Forum Discussion
Anuj_Gupta2155
Dec 10, 2022Copper Contributor
Extra Large Size of Excel file, even after deleting all spreadsheets
Hi Everyone. I do have an excel file with deleted spreadsheets but still the file size of the spreadsheet it too big. Can one help me with the reason why this is like that??
HansVogelaar
Dec 10, 2022MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Nguyen_Hoang_VietDec 16, 2022Copper ContributorI have the same problem.
Please check this file in the link below.
It is still 1.2 MB even i delete everything.
And it take me 30-60 seconds to open this file.
https://www.mediafire.com/file/eu4e2tlsl74s3zr/Test+remove+link.xlsx/file- Detlef_LewinDec 16, 2022Silver Contributor
First, the workbook is broken. I got a message from Excel it will repair the workbook and remove some parts.
Regarding your file size problem:
You did not delete the custom cell styles.
But they are not the problem this time.
You have a few thousand hidden (fancy) names in your workbook.
Get rid of them!
- Nguyen_Hoang_VietDec 16, 2022Copper Contributor
I am very grateful for your help.
Can you guide me how to remove these hidden (fancy) names in my workbook.