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