+ Reply to Thread
Results 1 to 4 of 4

Copy Sheet to New Workbook error?

  1. #1
    Big Rick
    Guest

    Copy Sheet to New Workbook error?

    Now that I am forced to use Excel 2007, I am finding this new error when attempting to copy a worksheet to a new workbook.
    Mind you, I am inserting as a new sheet!

    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.
    OK (button)
    And NO! It's not OK!

    I simply cannot grasp what the error means!?
    because it contains fewer rows and columns than the source workbook
    Fewer rows and columns compared to what?

    I also do not recall having any problems in previous versions of Excel (In regards to this matter).

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,356
    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.

  3. #3
    Big Rick
    Guest
    Thats news to me
    Thank you for the information!

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,356
    You're welcome. And it's actually 16k columns in Excel 2007 ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1