Excel 2010 large file size

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

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
 
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
 
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.
 
Back
Top