#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Copy Worksheet

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default Copy Worksheet

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Copy Worksheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy graph from a Worksheet based on a field in another Worksheet Jim K. - SGB Excel Worksheet Functions 2 July 6th 07 06:08 PM
Move/Copy or Copy/Insert worksheet? kjk Excel Discussion (Misc queries) 0 December 15th 06 03:40 PM
copy part of a worksheet into a worksheet in the same file/keepi. JTB Excel Worksheet Functions 1 September 23rd 06 09:13 AM
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 lukerush Excel Worksheet Functions 2 September 7th 06 05:05 PM
Worksheet 1 exact copy of worksheet 2, but in different order Lou@CRA Excel Discussion (Misc queries) 1 July 11th 06 05:49 PM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"