Extra Large Size of Excel file, even after deleting all spreadsheets

[Anuj_Gupta2155]

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??

[#2]

@Anuj_Gupta2155 

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?

[#3]

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

[#4]

@Nguyen_Hoang_Viet 

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!

[#5]

@Detlef Lewin 

I am very grateful for your help.
Can you guide me how to remove these hidden (fancy) names in my workbook.

[#6]

@Nguyen_Hoang_Viet 

Google Search can guide you:

https://www.google.com/search?q=delete+hidden+names+in+excel

[#7]

@Detlef Lewin 

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. 

[#8]

this is workbook with a blank sheet,why not create new file.

additionally，there are many external links
https://www.mrexcel.com/board/threads/breaking-external-link.1117815/

if you delete these links files,size will be smaller Apparently。