Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Excel sheets are not moving

shivam deval (student) (212 Points)

18 July 2012

Dear all,

I am trying to copy a excel worksheet from one workbook to another unable to move sheet...

Reply
Follow
Share

4 Replies

Sheli Sehrawat (SAP Business Consultant) (767 Points)
Replied 18 July 2012

can you copy the error message? I am not able to see what error you are getting!

Upgrade to CAclubindia Pro. Subscribe Now!

shivam deval (student) (212 Points)
Replied 18 July 2012

Excel cannot insert the sheets 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.

P K (Excel Developer) (130 Points)
Replied 18 July 2012

It seems that You are copying a sheet from excel 2007 or higher to a workbook of excel 2003.

Sheli Sehrawat (SAP Business Consultant) (767 Points)
Replied 18 July 2012

Sorry.. Not sure why this error comes. I first create a new workbook (Ctrl+N); then I just rightclick on the pane and select move or copy. In the pop-up window, I check "Copy" and in the dropdown I select the new workbook (Book1).