moving/copying a sheet from one workbook to another

[lezawang]

Hi
I can move/copy a sheet from Workbook1 to Workbook2, if Workbook2 was opened/created from Workbook1 by going to File-->New.

However, if I created Workbook2 by going to windows start menu-->Excel then, I wont be able to copy/move a sheet from Workbook1 to Workbook2.

Why is that and how can I fix that.

Thank you so much

 

[Norie]

It sounds like you are working with 2 separate instances of Excel and you can't copy/move sheet(s) between workbooks open in separate instances of Excel.