Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-03-2012
Member
 
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.

Reply With Quote
  #2  
Old 23-03-2012
Member
 
Join Date: Aug 2011
Posts: 576
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.
Reply With Quote
  #3  
Old 23-03-2012
Member
 
Join Date: Aug 2011
Posts: 539
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.
Reply With Quote
  #4  
Old 23-03-2012
Member
 
Join Date: Aug 2011
Posts: 690
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
Reply With Quote
  #5  
Old 23-03-2012
Member
 
Join Date: Jul 2011
Posts: 618
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is the best way to empty a large Microsoft Excel file"
Thread Thread Starter Forum Replies Last Post
How get rid large amount garbage cell in Microsoft Excel Iyyappan MS Office Support 2 21-02-2012 01:19 PM
Getting Error while opening Microsoft Excel 2000 file in Excel 2003 AbiaA MS Office Support 6 17-02-2012 12:18 PM
Unable to empty clipboard by using Microsoft Excel 2007 on Windows 7 fanish-war Windows Software 5 14-05-2011 10:34 AM
Configuring Internet Explorer 8 to open Excel file in to Microsoft Excel Aaghaz Technology & Internet 4 13-02-2011 09:37 AM
Backup Microsoft Outlook Contacts to Microsoft Excel File FlashX Tips & Tweaks 2 10-03-2009 10:50 AM


All times are GMT +5.5. The time now is 09:34 AM.