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??
Nguyen_Hoang_Viet
Dec 16, 2022Copper Contributor
I 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
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_Lewin
Dec 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.- Detlef_LewinDec 16, 2022Silver Contributor
- Nguyen_Hoang_VietDec 16, 2022Copper Contributor
Thank you so much.
It means a lot to me.
Some how our company have a lot file like this and it took me a lot of time . I've been trying to find a way to fix this for a long time. really thank you very much.