Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy and paste sheets to a different workbook

    Hi all,

    One of my colleagues is trying to copy the sheets from one workbook to the other and he gets an error please see the attached error screen,

    Many thanks
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Could try this ....
    Right click the tab of the sheet to be copied from
    Choose "Move or Copy"
    In the next window choose the "To book"
    Then choose the "Before sheet" or "(move to end)"
    Click the box for "Create a copy"
    Click "OK"


    HTH

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The only problem with that is there are over 30 sheets that he needs to copy, is there another solution to this? It used to work fine on Excel 2003.

    Thanks again

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Combinations of Tab or Shift key should work....
    Try holding the Tab key and click on sheet tabs to be copied. then use above steps.
    If sheets to be copied are consecutive, click on first sheet tab, Hold Shift, and click last sheet tab.


    PS: How did you do it in Excel 2003?
    Last edited by tfspry; 2011-04-01 at 11:49. Reason: added a PS

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It sounds like he is copying from an XL2007/10 workbook to an XL97-2003 workbook. Have you tried saving them both to the same type (xlsx or XLS) and then do the move?

    Steve

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Quote Originally Posted by tfspry View Post
    Combinations of Tab or Shift key should work....
    Try holding the Tab key and click on sheet tabs to be copied. then use above steps.
    If sheets to be copied are consecutive, click on first sheet tab, Hold Shift, and click last sheet tab.


    PS: How did you do it in Excel 2003?
    I think you wanted to say Ctrl or Shift?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by RetiredGeek View Post
    I think you wanted to say Ctrl or Shift?
    RG - You are absolutely correct. Thanks for the correction!!!

    I think Steve is onto the problem. They might be trying to copy an .xlsx "Sheet" to an .xls workbook.


    My post should have said....
    Combinations of Ctrl or Shift key should work....
    Try holding the Ctrl key and click on sheet tabs to be copied. then use above steps from Post #2.
    If sheets to be copied are consecutive, click on first sheet tab, Hold Shift, and click last sheet tab to be copied.
    Last edited by tfspry; 2011-04-01 at 16:23. Reason: Corrected post for the RG catch

  8. #8
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hi

    One of the files had the extension as xlsm (contained a macro), saved the file to be as xls and it works now. thanks for all your help

Posting Permissions

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