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.
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.
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 is a huge difference..