rats for you. sorry, wasn't aware of the issue. i hope bob can help
you work it out.
susan



On Oct 31, 1:19 pm, Rick S. wrote:
Initially I do save a worksheet as a new workbook. But the second workbook I
open and the sheet I select to copy will not allow me to copy the entire
sheet to a new workbook, this is an internal Excel 2007 error, hence I am
using Copy/Paste data instead.

Original Excel 2007 Error

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 Copy
and Paste commands to insert it into the sheets of another workbook.

I had this posted on another forum.http://www.excelforum.com/showthread...40#post1845240
And the answer is.....

Author: shg (Moderator at ExcelTip.com)
Attempting to copy a worksheet from an older version of Excel into a 2007
workbook? Excel 2007, in contrast to older versions, has 1M rows and 64K(?)
columns.

So select all the cells in the old worksheet (Ctrl+A, or click in the upper
left corner of the row and column headers), copy, and paste into the 2007
worksheet.

I am forced to copy/paste. :shrugs shoulders:

--
Regards

Rick
XP Pro
Office 2007



"Susan" wrote:
no XP pro here, but have found copy/paste can be a nightmare filled
with bugs. why not just save that sheet as a new workbook? i know
i've seen that done........
just an idea.
susan