+ Reply to Thread
Results 1 to 7 of 7

Cannot reduce size of file although deleted whole data from all sheets

  1. #1
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Cannot reduce size of file although deleted whole data from all sheets

    I Cannot reduce size of file although deleted whole data from all sheets. Please find attachment in this link https://files.fm/u/2t57rryb

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    O365 (PC) V 2210
    Posts
    35,756

    Re: Cannot reduce size of file although deleted whole data from all sheets

    My security software has blocked your site....

    Take a look here. This is th emost usual cause:

    https://www.techrepublic.com/blog/mi...orkbook-bloat/
    Glenn



  3. #3
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Cannot reduce size of file although deleted whole data from all sheets

    My file was normal size before, I think following is the thing that caused it to go 2.5MB in size.
    I copies 0.5 from a cell, then selected one column and PasteSpecial in it as "Add". Then even I deleted, Cleared contents for everything but size doesn't go back to normal.

  4. #4
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Cannot reduce size of file although deleted whole data from all sheets

    Hi caabdul

    I could download it, but Glenn's pointer to the usual cause isn't the culprit in this case - although, all too often, it is. I have tried deleting all the columns, and all the rows, but the last cell keeps on defaulting to A1048576, and this is what's causing the huge file size.

    You could delete this tab, and that would fix it, bringing the workbook size to 42kb, but I admit to being a little mystified at the underlying cause.

    As an aside, I suggest you delete this file from files.fm - it appears to have some personal data left over which hasn't been deleted.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,041

    Re: Cannot reduce size of file although deleted whole data from all sheets

    I havent read Glen's link.

    Create a new file and copy each page from the old file to the new file.
    Save the new file.

    See if that's any better, sometimes it works.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  6. #6
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Cannot reduce size of file although deleted whole data from all sheets

    Quote Originally Posted by Special-K View Post
    Create a new file and copy each page from the old file to the new file.
    I also tried this - it didn't work.
    I also tried the old chestnut of saving to .html, and then converting back to an Excel file. No joy there …

    DominicB

  7. #7
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Cannot reduce size of file although deleted whole data from all sheets

    as a way
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2013, 03:18 PM
  2. Reduce File size
    By pedjvak in forum Excel General
    Replies: 3
    Last Post: 01-22-2013, 06:30 AM
  3. Replies: 8
    Last Post: 11-28-2012, 02:33 AM
  4. Help me reduce 30 mb file size
    By ZenButcher in forum Excel General
    Replies: 6
    Last Post: 11-06-2009, 03:34 AM
  5. Reduce File Size
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2008, 09:41 AM
  6. Reduce File Size
    By tbaker897 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2008, 08:24 AM
  7. Replies: 2
    Last Post: 09-21-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1