Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move/Copy sheet to another workbook error
I am using Excel 2007 and want to move a sheet from one workbook to another
workbook and I keep getting this error message: Excel cannot insert the sheet 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 do I get this message? I don't want to copy & paste my sheet cause then I have to re-format me sheet how I had it in the other workbook. Can anyone tell me how to get passed this? Thank you, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move/Copy sheet to another workbook error
Renee wrote:
I am using Excel 2007 and want to move a sheet from one workbook to another workbook and I keep getting this error message: Excel cannot insert the sheet 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 do I get this message? I don't want to copy & paste my sheet cause then I have to re-format me sheet how I had it in the other workbook. Can anyone tell me how to get passed this? Thank you, This happens when you move a sheet created in 2007 to a workbook created in 2003 or previous. You need to save the destination workbook in 2007 format, then move the worksheet. You can also move the sheets the otehr way. Start with the moving worksheet in a new workbook, then move the other worksheets into this new workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move/Copy sheet to another workbook error
Okay. Thank you.
"Tim Otero" wrote: Renee wrote: I am using Excel 2007 and want to move a sheet from one workbook to another workbook and I keep getting this error message: Excel cannot insert the sheet 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 do I get this message? I don't want to copy & paste my sheet cause then I have to re-format me sheet how I had it in the other workbook. Can anyone tell me how to get passed this? Thank you, This happens when you move a sheet created in 2007 to a workbook created in 2003 or previous. You need to save the destination workbook in 2007 format, then move the worksheet. You can also move the sheets the otehr way. Start with the moving worksheet in a new workbook, then move the other worksheets into this new workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Move Worksheet from one Workbook to another | Excel Discussion (Misc queries) | |||
move or copy sheet | Excel Worksheet Functions | |||
Copy Sheet and move to end | Excel Discussion (Misc queries) | |||
copy/move sheets within workbook | Excel Discussion (Misc queries) | |||
I would like to move from sheet to sheet in a workbook using keybo | New Users to Excel |