Excel 2010. I am trying to copy a worksheet from one workbook to another. Both are .XLXS files and I have been able to do this for quite some time with no problems, but recently when I try to copy a worksheet I get the message... 'Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns that the source workbook. To move or copy the data to the destination workbook, you can select the data and then use Copy and Paste commands to insert it into the sheets of another workbook.'
I did the copy and paste thing but lost all the formatting so I tried Paste Special and got the option to paste as Unicode or Text, not option to paste formating.
I can copy a worksheet within the same workbook, and can copy a worksheet to a 'new workbook', but cannot copy a worksheet from one workbook to another.
I did the copy and paste thing but lost all the formatting so I tried Paste Special and got the option to paste as Unicode or Text, not option to paste formating.
I can copy a worksheet within the same workbook, and can copy a worksheet to a 'new workbook', but cannot copy a worksheet from one workbook to another.