Cant copy a worksheet to another workbook

**mingali** · 11-03-2009, 03:14 AM

Hi,

Currently using excel 2007. This is the first time i encounter this type of problem. I tried to copy a worksheet to a new workbook but failed. Anyone know how to resolve this problem?

Thanks

**Rahul Nagar** · 11-03-2009, 03:45 AM

Hello Mingali,

Can you please let me know what error are you getting.

Regards
Rahul

**mingali** · 11-03-2009, 04:09 AM

No error at all. it just simply not working. like no respond at all.

When i copy the worksheet in the same workbook, it works. but when i tried to copy it to another workbook, it fails. What i do now, is to highlight the whole worksheet and copy and paste it to the new workbook.

**Rahul Nagar** · 11-03-2009, 05:03 AM

Please right click on sheet at the below left corner
and click move-copy option.

**mingali** · 11-03-2009, 05:14 AM

that is exactly what i did and excel did not respond

GMANFG · 11-07-2009, 08:52 PM

Try the tip at this site. You may need to remove all sheets, except the one you want to copy to the other workbook. Also, if the worksheet you are copying is not .xls, but is a xlsm extension, be sure to changes .xls to .xlsm in the code.

http://excel.tips.net/Pages/T002409_...Workbooks.html