I recently had to upgrade to Office 2007. I migrated all my excel workbooks
and templates to the new office 2007. For two weeks in a row I was able to
insert a template into an excel workbook. I click on the last sheet of the
workbook and click on insert and it shows me my template and I click on it
and it pops into the workbook. This week I tried to do the same thing and
got the following Message:
"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."
Why is this happening all of a sudden with the same template. My workbook
contains sheet tabls for each week of 2007 thru Apr 15 week. My template
only has one sheet. I have re-created the template in a workbook with only
one sheet and saved it in the templates folder, but it still won't work.
Any suggestions?

Just a guess but it looks as if the workbooks where you were successful were
Excel 2003 (or earlier) workbooks (that is, they had 65k rows) and where you
were not it was with an Excel 2007 workbook. The file name extension is not
determinative; you have to look at the number of rows available.

--
Jim
"windavis" wrote in message
...
I recently had to upgrade to Office 2007. I migrated all my excel
workbooks
and templates to the new office 2007. For two weeks in a row I was able
to
insert a template into an excel workbook. I click on the last sheet of
the
workbook and click on insert and it shows me my template and I click on it
and it pops into the workbook. This week I tried to do the same thing and
got the following Message:
"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."
Why is this happening all of a sudden with the same template. My workbook
contains sheet tabls for each week of 2007 thru Apr 15 week. My template
only has one sheet. I have re-created the template in a workbook with
only
one sheet and saved it in the templates folder, but it still won't work.
Any suggestions?

Jim:

That was exactly the problem. I am going to try to fix the template to have
the same number of rows as my workbook and see if that works. If not, then I
will just have to copy over all the spreadsheets to a new workbook.
Thanks for your help.

"Jim Rech" wrote:

Just a guess but it looks as if the workbooks where you were successful were
Excel 2003 (or earlier) workbooks (that is, they had 65k rows) and where you
were not it was with an Excel 2007 workbook. The file name extension is not
determinative; you have to look at the number of rows available.

--
Jim
"windavis" wrote in message
...
I recently had to upgrade to Office 2007. I migrated all my excel
workbooks
and templates to the new office 2007. For two weeks in a row I was able
to
insert a template into an excel workbook. I click on the last sheet of
the
workbook and click on insert and it shows me my template and I click on it
and it pops into the workbook. This week I tried to do the same thing and
got the following Message:
"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."
Why is this happening all of a sudden with the same template. My workbook
contains sheet tabls for each week of 2007 thru Apr 15 week. My template
only has one sheet. I have re-created the template in a workbook with
only
one sheet and saved it in the templates folder, but it still won't work.
Any suggestions?

How do you reduce the total number of rows in a sheet?

"windavis" wrote:

Jim:

That was exactly the problem. I am going to try to fix the template to have
the same number of rows as my workbook and see if that works. If not, then I
will just have to copy over all the spreadsheets to a new workbook.
Thanks for your help.

"Jim Rech" wrote:

Just a guess but it looks as if the workbooks where you were successful were
Excel 2003 (or earlier) workbooks (that is, they had 65k rows) and where you
were not it was with an Excel 2007 workbook. The file name extension is not
determinative; you have to look at the number of rows available.

--
Jim
"windavis" wrote in message
...
I recently had to upgrade to Office 2007. I migrated all my excel
workbooks
and templates to the new office 2007. For two weeks in a row I was able
to
insert a template into an excel workbook. I click on the last sheet of
the
workbook and click on insert and it shows me my template and I click on it
and it pops into the workbook. This week I tried to do the same thing and
got the following Message:
"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."
Why is this happening all of a sudden with the same template. My workbook
contains sheet tabls for each week of 2007 thru Apr 15 week. My template
only has one sheet. I have re-created the template in a workbook with
only
one sheet and saved it in the templates folder, but it still won't work.
Any suggestions?

You can't, you can make it look smaller by hiding them

--


Regards,


Peo Sjoblom

"Sdeleon" wrote in message
...
How do you reduce the total number of rows in a sheet?

"windavis" wrote:

Jim:

That was exactly the problem. I am going to try to fix the template to
have
the same number of rows as my workbook and see if that works. If not,
then I
will just have to copy over all the spreadsheets to a new workbook.
Thanks for your help.

"Jim Rech" wrote:

Just a guess but it looks as if the workbooks where you were successful
were
Excel 2003 (or earlier) workbooks (that is, they had 65k rows) and
where you
were not it was with an Excel 2007 workbook. The file name extension
is not
determinative; you have to look at the number of rows available.

--
Jim
"windavis" wrote in message
...
I recently had to upgrade to Office 2007. I migrated all my excel
workbooks
and templates to the new office 2007. For two weeks in a row I was
able
to
insert a template into an excel workbook. I click on the last sheet
of
the
workbook and click on insert and it shows me my template and I click
on it
and it pops into the workbook. This week I tried to do the same
thing and
got the following Message:
"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."
Why is this happening all of a sudden with the same template. My
workbook
contains sheet tabls for each week of 2007 thru Apr 15 week. My
template
only has one sheet. I have re-created the template in a workbook
with
only
one sheet and saved it in the templates folder, but it still won't
work.
Any suggestions?