Forum Discussion

Anuj_Gupta2155's avatar
Anuj_Gupta2155
Copper Contributor
Dec 10, 2022

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

excel

7 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 10, 2022

    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?

    • Nguyen_Hoang_Viet's avatar
      Nguyen_Hoang_Viet
      Copper Contributor
      Dec 16, 2022
      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
      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Dec 16, 2022

        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!

         

Resources