Excel 2010 large file size
 

Hi
i am using a 2010 spreadsheet to log project action lists.
i use filters on this spreadsheet. The spreadsheet is 10 mb although
there is nothing complicated.could you please let me know what might
hage gone wrojg and how i rectify it.

Thanks
brian

Hi Brian,

Have you checked for extra columns / rows that don't need to be there?
Check if your scroll bars are particularly small as this is a sure giveaway that you do have these extras.

If you accidentally move all the way down to the last row (1,000,000+) and put a space in one of the cells down there, the spreadsheet will assume you're using all the space down to that row and this will drastically increase the file size. Same could happen with columns.

Try scrolling to the last row you're using and highlighting and deleting all the rows below it. Then select a cell near the top and save the file.

If it's not that, then the only other things I can think of would be excessive conditional formatting, change history or data ranges in other workbooks.
These I find are the usual suspects for increased file size.

Hope that helps...

S. :)

Excel 2010 large file size
 

Check your used range.

On any sheet hit CTRL + End and see where Excel takes you.

If far beyond your actual used range, delete rows below and column
right of your range s on each sheet.

Save, close and re-open.


Gord

On Sat, 19 May 2012 23:09:41 -0700 (PDT),
" wrote:

Hi
i am using a 2010 spreadsheet to log project action lists.
i use filters on this spreadsheet. The spreadsheet is 10 mb although
there is nothing complicated.could you please let me know what might
hage gone wrojg and how i rectify it.

Thanks
brian

Excel 2010 large file size
 

Adding to what gord has suggested & to give you an idea as to why it is
the size it is..

Previous versions of Excel worksheets were approx 65K rows where-as 2010
worksheets are 1,048,576 so that's a huge difference..

HTH
Mick.