Results 1 to 5 of 5

Thread: What is the best way to empty a large Microsoft Excel file

  1. #1
    Join Date
    Feb 2012
    Posts
    14

    What is the best way to empty a large Microsoft Excel file

    I am looking for some helpful ways to make my excel sheet a little less bulky. I have deleted all sheets, and contents from my excel file, but it's still 2Mb in size. When I zip it, it's only 90K Bytes. (A blank excel file is usually 90K Bytes) Why is my empty file so large. It was originally 5 Meg, and I deleted all sheets, formulas, and VB codes. Right now there is nothing (except one empty sheet), but the size is still 2M. Please respond.

  2. #2
    Join Date
    Aug 2011
    Posts
    582

    Re: What is the best way to empty a large Microsoft Excel file

    On the one hand you can sometimes Excel from the menu File > Open to go, and then click on the file open dialog in the right place at the bottom open, click on the arrow and open repair. Sometimes what I find is that Excel counts unused rows as part of the file size. So what I do is highlight all the rows from the first unused one to the last one, i.e. ctrl+g to bring up the goto box, then Ax:a65536, and delete the rows, where x is the first row after all your work ends. This normally reduces the file size significantly.

  3. #3
    Join Date
    Aug 2011
    Posts
    542

    Re: What is the best way to empty a large Microsoft Excel file

    Such problems are not noticed in the newer version of Microsoft Excel. You need to carefully watch the files themselves, did not get there any debris, such as pictures, ole-objects, textures, graphics, the names of forgotten, hidden, and the cell sheets. All sorts of reasons may be. Did you accidentally save it as a Picture file. If not why don't you just hit "print preview" and see what it looks like. Chances are there is an image or something in it. Maybe you selected a huge print area on accident. Check the header and the footer through the print preview as well.

  4. #4
    Join Date
    Aug 2011
    Posts
    700

    Re: What is the best way to empty a large Microsoft Excel file

    Hmmm, you are trying to email a workbook that has no macros, and has the one requisite sheet, and that sheet is empty. At this point, I expect there is nothing left that you want to email. After deleting rows and column, you probably will also have to save the file. The check of what you have for a last cell is Ctrl+End

  5. #5
    Join Date
    Jul 2011
    Posts
    627

    Re: What is the best way to empty a large Microsoft Excel file

    I have read all the threads on all the forums about workbooks that have become too large. I was having the same problem. File started off about 5mb and after a few weeks had somehow worked up to about 20mb for no real reason. Yes, it saved a few kb when I deleted all the unused cells at the end of the data rows and columns and saved it again, but I've found the real reason for these huge files. Take sharing off your workbook!! Then save and save again. It will reduce the file size by 400% or so.

Similar Threads

  1. How get rid large amount garbage cell in Microsoft Excel
    By Iyyappan in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:19 PM
  2. Replies: 6
    Last Post: 17-02-2012, 12:18 PM
  3. Replies: 5
    Last Post: 14-05-2011, 10:34 AM
  4. Replies: 4
    Last Post: 13-02-2011, 09:37 AM
  5. Replies: 2
    Last Post: 10-03-2009, 10:50 AM

Posting Permissions

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