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
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.
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.
Related:
- Unable to copy selected cells after apply autofilter function
- How to apply @ in laptop - Guide
- Apply the moderate effect smartart style - Guide
- Unable to ping computer on same network - Guide
- Apply watermark to all pages word - Guide
- Unable to load authentication library exiting ✓ - Counter Strike (CS) Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 4, 2012 at 07:49 AM
Dec 4, 2012 at 07:49 AM
How are you filtering on top 10 ? Also are you trying to paste on same sheet ?
stonehendriks
Posts
1
Registration date
Tuesday April 30, 2013
Status
Member
Last seen
April 30, 2013
Apr 30, 2013 at 03:17 AM
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
You need to use download microsoft excel repair file software
http://www.excel.repairtoolboxx.com will solve your problem without changing source info
Dec 4, 2012 at 10:46 AM
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.
Dec 4, 2012 at 11:09 AM