Move or Copy Worksheet

[Andi]

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

 

[bj]

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]

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]

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]

if they are not the same, what do I do?

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

 

[bj]

After making the statement I tried several things to make a difference in the
numbers and couldn't in 2003

I have had another thought, I get occasional problems with merged cells
try selecting all and format cells unmerge
then try to move

 

[Andi]

Well, for some reason it seemed to work this time... with NO changes. Did
everything exactly the same. So, it seems we have an intermittent issue.
There are some merged cells and there are some grouped cells. It has not
been an issue in the past. It's basically a template the admins complete.
When they are done, I copy their individual worksheets into my master
workbook. I can't imagine why "sometimes" this is an issue.