Excel Templates in Excel 2007

G

Guest

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?
 
J

Jim Rech

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top