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?