Previous Topic Next Topic

Unable to copy selected cells after apply autofilter function

Solved/Closed
venus1060 Posts 2 Registration date Tuesday 4 December 2012 Status Member Last seen 4 December 2012 - 4 Dec 2012 à 06:16
stonehendriks Posts 1 Registration date Tuesday 30 April 2013 Status Member Last seen 30 April 2013 - 30 Apr 2013 à 03:17
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.
Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Dec 2012 à 07:49
How are you filtering on top 10 ? Also are you trying to paste on same sheet ?
venus1060 Posts 2 Registration date Tuesday 4 December 2012 Status Member Last seen 4 December 2012
4 Dec 2012 à 10:46
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.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Dec 2012 à 11:09
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
Réponse 2 / 2
stonehendriks Posts 1 Registration date Tuesday 30 April 2013 Status Member Last seen 30 April 2013
30 Apr 2013 à 03:17
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

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Counter Strike unable to load authentication libra
0250 -
bilstein -

16 responses
Required Solution for Unable to load authentication library
Ahmed -
HelpiOS -

1 response
Can't join WhatsApp group chat
Matt92 -
vocalkeny -

25 responses
Red exclamation mark keeps appearing next to Facebook messages.
Anonymous0332 -
hiensumo.0912 -

2 responses