Unable to copy selected cells after apply autofilter function

Solved/Closed
venus1060 Posts 2 Registration date Tuesday December 4, 2012 Status Member Last seen December 4, 2012 - Dec 4, 2012 at 06:16 AM
stonehendriks Posts 1 Registration date Tuesday April 30, 2013 Status Member Last seen April 30, 2013 - Apr 30, 2013 at 03:17 AM
Dear All,

I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When I apply Autofilter to select top 10 locations based on volume, I get the top 10 locations.
But, the problem appears, when I copy the top 10 locations and related volume. By default only top10 locations should be selected, but excel selects all of them. But when I click on "Reapply" Filter, it can work well. Is it because of my Excel setting issue? Please advice if you have been experience this issue before.


Thanks in advance.

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Dec 4, 2012 at 07:49 AM
How are you filtering on top 10 ? Also are you trying to paste on same sheet ?
0
venus1060 Posts 2 Registration date Tuesday December 4, 2012 Status Member Last seen December 4, 2012
Dec 4, 2012 at 10:46 AM
Hi Rizvisa,


I tried to copy and paste the selected cells to new worksheet and this issue prompted. Basically before I reformat and upgrade OS to window 7, I do not see this issue happen. This issue just prompted after upgrading OS to Window 7. But there is something weird encounter, my friedn also using Window 7 but they do not face this issue whereby I have to click on the "reapply" button (under "Data" Tab --> Sort and filter) then only I can copy and paste the selected cells. Please don't mind to share if you have any idea to resolve this issue.

Thanks.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Dec 4, 2012 at 11:09 AM
I just tried on win 7 / office 2010. I was able to it, What version of excel you are using. Also could you post a sample workbook that has that issue on some public file share site and post back the link to the file back here. From my sample run, I also did not had any issue
0
stonehendriks Posts 1 Registration date Tuesday April 30, 2013 Status Member Last seen April 30, 2013
Apr 30, 2013 at 03:17 AM
These cells could be crashed by any reason, I had such unpleasant experience in my work with Excel files.

You need to use download microsoft excel repair file software

http://www.excel.repairtoolboxx.com will solve your problem without changing source info
0