Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

(Using Excel 2010) I am trying to copy a worksheet that has text boxes and paste it into an existing workbook. When I copy the worksheet (CTRL+A+A or right click-copy) and paste the worksheet in the existing workbook, all the data is there except the text boxes. I have verified that the "cut, copy, and sort inserted object with their parent cells" is checked. The object positioning is set as "move and size with cells" (but I have tried copy/paste with the other options checked as well). If I copy/paste in the same workbook, everything copies just fine. Also have tried selecting the text box and then selecting the worksheet but I get an error message "that command cannot be used on multiple selections".

The problem seems to be only when going from one workbook to another workbook.

Any ideas would be appreciated!

share|improve this question

1 Answer 1

If I click on the tab of the worksheet I want to move and select "move or copy" and then select to move or copy to an existing workbook (selectable from the dropdown) my text boxes get moved or copied across.

share|improve this answer
    
Thanks for that idea. I tried that and get an error message: "excel cannot insert into destination workbook because it contains fewwer rows and columns than the source workbook..." However, it will work if I choose "new workbook." I accidentally figured out my problem yesterday. I believe it is a bug with the new file etx .xlsx. Text boxes will not copy into a new workbook if both files are .xlsx (the new file ext) but if both files are the old file ext .xls text boxes copy to a new workbook just fine. –  A.C. Apr 20 '12 at 13:14
    
This works for me even if the two files are .xlsx - More likely you are trying to move an .xlsx sheet into an old .xls workbook - then one is much bigger than the other. –  BJ292 Apr 21 '12 at 6:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.