View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Copy sheet to different workbook sizing error message

Save the source workbook with regular file extension, "xlsx", not the
extension used for larger file size.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jvwulffen" wrote:

When trying to create a copy of a worksheet and inserting into a different
workbook I receive this error message:
excell cannot insert the sheets into the destination workbook, because it
contains fewer rows and columns than the source workbook. Goes on to tell me
to C&P into other workbook which I don't want to do.
I am fairly certain there is a way to "delete" the empty rows/columns taking
up space and making workbook larger than necessary giving me the ability to
then insert it into the other workbook.