Excel 2010 large file size

[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

 

[Gord Dibben]

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

 

[Vacuum Sealed]

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.