Move or Copy Worksheet
if they are not the same, what do I do?
"bj" wrote:
goto the little block at the intersection of the column and row lables
if 2007 is similar to 2003, clicking on it will give the number of rows and
columns which are being selected
if they say the same, I do not know wht the issue is
"Andi" wrote:
I tried it while both were still saved in the old version as .xls. Then I
tried saving each through "save as" in the new version with .xlsx.
It's just not working. Even more unusual is that it worked on a few sheets
but not others.
"bj" wrote:
I am not familiar with 2007 but have you saved the file you are moving to as
a 23007 excel workbook, It soulnds as though it is saving as one of the
older versions.
"Andi" wrote:
I am trying to move a worksheet from one workbook to another. I have never
had a problem with this in the past, but now that I have Office 2007 I seem
to be having trouble.
The error message I receive is: Excel cannot insert the sheets into the
destination workbook, because it contains fewer rows and columns than the
source workbook. To move or copy the data to the destination workbook, you
can select the data, and then use the Copy and Paste commands to insert it
into the sheets of another workbook.
Of course, that is not much of an option as it looses all my formatting,
grouping, etc.
Could you please offer some assistance?
Thanks
|