• 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.

File Size is Too Large

S

Sarfraz

New Member
Dear Sir,

I am using Excel 2007 and when I save my workbook the total size of workbook getting to large and in such I need to go and save MANUALLY in excel 2003 format.

What is the best solution for this problem.
 
Sarfraz: How many sheets do you have in the workbook? And how many used rows and columns are in each sheet?

Also, in each sheet, select any cell and push Ctrl + End, and take note of which cell gets selected. This will take you to where Excel thinks your data ends, called the Used Range. Sometimes EXcel gets confused, and thinks your used range extends to the very bottom of the grid.

See my guest posts at the following links for more suggestions:
http://chandoo.org/wp/2013/09/29/i-said-your-spreadsheet-is-really-fat-not-real-phat/
http://chandoo.org/wp/2014/01/17/big-trouble-in-little-spreadsheet/
 
You must log in or register to reply here.
Back
Top