Page 1 of 2 1 2 LastLast
Results 1 to 10 of 13

Thread: Excel oddity

  1. #1
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0

    Excel oddity



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Open two separate sessions of Excel.
    Put any data in A1:B10
    Hide rows 2:9
    Select A1:B10, use goto special/Visible cells only.
    Copy
    In a 2nd sheet of same workbook, paste. You get what you expect.
    In a sheet from the 2nd session of Excel, Paste. You DON'T get what you expect.

    Any good explanation of why the difference?

  2. #2
    This works correctly if you open excel and create a new workbook from within.

    When you open excel twice from the start menu it opens in a separate instance and you lose some functionality when you try to go between the two and you can't access macros from workbooks in the other instance.

    Not really sure why this is or what the limitations are, I would be interested in understanding it as well.

    Jesse

  3. #3
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0
    Actually, you CAN access macros in the other instance - mainly need to set a reference to it. However, what you did was reiterate the oddity -- I did say it works fine in the same instance, but odd in a 2nd instance.

  4. #4
    Yes, I did reiterate only I said second workbook in the same instance vs second worksheet.

    Forum is new, I was looking for excuses to post. Didn't intend to offend.

  5. #5
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0
    :-) -- I wasn't offended.

  6. #6
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Let me preface with, "Bob, I have no idea."

    Perhaps it's a different clipboard of the two, and special cells do not get passed the same. Have you tried other types of special cells? I haven't, but will in a little bit.
    Regards,
    Zack Barresse

  7. #7
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0
    Figured it was a different clipboard but still falls under the category of "oddity", IMHO

  8. #8
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Absolutely. I wouldn't expect you to find anything less.
    Regards,
    Zack Barresse

  9. #9
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Quote Originally Posted by Zack Barresse View Post
    Absolutely. I wouldn't expect you to find anything less.
    LOL!

    Interesting though... if you're using Excel 2010, right click the sheet in the second workbook and choose Paste Special -> Match Destination Formatting. It gives you what you'd expect. So obviously, clipboard differences or not, the original selection is still held somewhere.

    I would agree that the default should match with the original Excel instance though.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  10. #10
    It's the old Windows Clipboard - Excel Clipboard thing, isn't it?
    Jon Peltier
    Peltier Technical Services, Inc.
    http://peltiertech.com

Page 1 of 2 1 2 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •