moving/copying a sheet from one workbook to another

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,539
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,372
Messages
5,444,067
Members
405,265
Latest member
Iram

This Week's Hot Topics

Top