Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When I try to copy a worksheet from one spreadsheet to another, I get the
following error message: "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook.........." It then wants me to copy and paste the data instead. Any help would be appreciated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Are you using Excel 2007 and you have one spreadsheet created in 2007 format
and another in previous versions format? Then you need to either save a copy of the workbook as 97-2003 or copy and paste -- Regards, Peo Sjoblom "mman493" wrote in message ... When I try to copy a worksheet from one spreadsheet to another, I get the following error message: "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook.........." It then wants me to copy and paste the data instead. Any help would be appreciated. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for the reply. Both are save as 97 -2003 spreadsheets. I can copy a
worksheet from A to B, but not from B to A? "Peo Sjoblom" wrote: Are you using Excel 2007 and you have one spreadsheet created in 2007 format and another in previous versions format? Then you need to either save a copy of the workbook as 97-2003 or copy and paste -- Regards, Peo Sjoblom "mman493" wrote in message ... When I try to copy a worksheet from one spreadsheet to another, I get the following error message: "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook.........." It then wants me to copy and paste the data instead. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) |