I have upgraded my system from Excel 2000 to 2007.
Since I have done this when ever I do a filter and copy the data for the
filtered range the data gets copied into the unfiltered rows even when the
the data set is less than 5000 rows.

Is this a issue with excel settings?