• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

default copy visible/hidden different on two machines both running excel 2010

I

indesignkat

Member
Hello,

My colleague recently returned to work here with a different computer and it's acting differently than he is accustomed to. When working with a filter and copying data to paste to another workbook, it is copying rows that are filtered out (hidden) and pasting them into the new book. He wants it to only copy the visible rows. On my machine it only copies/pastes the visible rows by default, and I can't find a setting to change that behavior.

I know there are ways to get around this, like control-g, but I'm trying to figure out why the default behavior is different and how to change the default. We're both on Windows 10 with Office Standard 2010, version 14.0.4760.1000

thanks,
 
Hi, indesignkat!

I think that the problem doesn't rely on differences of the Windows configuration of both machines since copy & paste filtered rows is entirely handled by Excel. Said so, please try two things:
a) Check and post what versions of Excel are running in both computers.
b) In the new machine build a sample file with 5 rows x 5 columns data, apply proper filters and try copying it to a new workbook there, and let us know what happens.
c) If b) worked fine repeat the procedure starting from the old machine (not copying the previous file).
d) If c) worked fine, consider uploading the original file where you detected the issue.

Regards!
 
Thank you for the reply. As noted in my original post, both computers are running office 2010 v14.0.4760.1000. 32-bit, if that matters.

Sample file, original file, results are always the same. When we do it on his machine, it copies & pastes the hidden rows as well as the visible ones. On my machine it only copies & pastes the visible rows.

Someone else mentioned to me that they were able to reproduce this behavior when copy/pasting between workbooks in different instances of excel. I just watched my colleague select the active (visible) area of a filtered group and then paste into an unfiltered area of the same worksheet and it still pasted all the hidden rows. To be specific, he had around 5000 rows and about 7 columns of data. He had it filtered in such a way that only about 15 rows were visible. He selected the visible area, right-click, copy, then right-click in a5020, paste, and 5000 rows of data pasted in. He is not selecting entire rows or columns or headers, just the visible cells in the filtered area.
 
Hi, indesignkat!
My bad, didn't read as carefully as I should.
After trying what Chihiro suggested, if the issue is still present consider uploading the file with the issue.
Regards!
 
Using ctrl-g to select visible cells only works fine for him, and that's what he's currently doing as a workaround until we can sort out why the default behavior is so odd. And SirJB7, the file he's using doesn't matter. Any file shows this behavior.

EDIT: the thing that's nagging at my brain is the way excel will sometimes perpetuate things. Like if you do a text-to-columns and then later paste data, it will apply the same text-to-columns method when you paste, automatically, without you initiating the action. I can't think of anything outside of select special that relates to selecting hidden/visible lines, though.
 
You may be able to fix the issue by doing one of the following.
1) Do complete restart of the computer
2) Use program manager to repair Office installation
3) Locate "XLSTART" folder and remove contents of that folder

For the 3rd option, do a search on search engine and read articles to ensure you understand the impact.
 
You must log in or register to reply here.
Back
Top