• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shrinking Excel 2010 File Size

C

crack100

New Member
Hi ,


I am using Excel 2010 to build a calculation intensive workbook. I have written some macros as well. The file extension is xlsm. It takes a lot of time to open the file nearly 55 seconds ( I do not quite understand the reason behind it ) . The file size with extension xlsm is 7.5 MB. But when I save the file as xlsb extension the file size reduces to 3.5 MB . However the time it takes to open the file remains the file. Could you please help me to save time when I open my file. Also tips on how can I reduced my file size keeping the extension xlsm. Looking forward for your reply.


Thanks in advance
 
Good day crack100


Save the file as a Excel Binary this will reduce the file size and is the better choice for Excel workbook with a very large size
 
Hi, crack100!

For further assistance, consider uploading a sample file, it'd be very useful for those who read this and might be able to help you. Thank you.

Regards!
 
Crack100

Does the file have data links to other spreadsheets or Databases etc ?


If these links aren't available Excel or the O/S will try to establish the links and result in a very slow file opening time


If you have setup an array of thousands of SumProduct's or other volatile formulas which possibly reference thousands of cells each this can also slow down opening, but that will also slow down regular calculations
 
Hi Crack100,


You may formatted all cells in some of sheets.(cells.select) It is suggested to format only used ranges. You may used filter option in any of your sheet. Please clear the filter before close the file.
 
Hi ,


The following link may be helpful :


http://excel.tips.net/T002402_Speeding_Up_Opening_and_Saving_a_Workbook.html


Narayan
 
Crack100


Another idea maybe to rebuild Excel's internal calculation dependency tree which may have been corrupted


Save the file as a Backup somewhere

Press Ctrl-Alt-Shift-F9

Then Save the file


Close Excel and re-open the file
 
Thank you all for the great suggestions.


My file do not have links with other External Files. It just has internal links in the workbook , lots of Vlookups and Sumifs and DataValidation.


@Dhamo : Could you please explain me more what is your suggestion. I could not really understand it.
 
You must log in or register to reply here.
Back
Top