Excel - Moving/Copying Sheets program issue

DaddyTorgo · 02-01-2011, 09:26 AM

Weird issue. If I go to move or copy a worksheet to another workbook that is open, the other workbook isn't showing up as an option, only "new book" shows up as an option.

Thoughts? Solutions? Reinstall/Repair MS Office?

Logan · 02-01-2011, 09:28 AM

Is the one you're trying to move to read-only or otherwise protected?

Butter · 02-01-2011, 09:39 AM

I have this sometimes, and this may not be your problem, but this is how I fixed my problem. Close the 2nd workbook down and re-open using the Open function in Excel with the first workbook open instead of double-clicking on the file so that they are both open in the same working copy of Excel.

FrogMan · 02-01-2011, 09:46 AM

Quote:

Originally Posted by Butter_of_69

I have this sometimes, and this may not be your problem, but this is how I fixed my problem. Close the 2nd workbook down and re-open using the Open function in Excel with the first workbook open instead of double-clicking on the file so that they are both open in the same working copy of Excel.

yeah, what he said. What happens sometimes is that your two sheets are open in two instances of Excel while they need to be in the same instance for the copy/move to work properly. Reopening insures that you are in the same instance of Excel for both sheets.

FM

DaddyTorgo · 02-01-2011, 09:59 AM

Aaah. That's probably what it is, yeah. I'm big on opening them in separate instances of Excel so I can have them open on two screens and all.

02-01-2011, 09:39 AM	#3
Butter Coordinator Join Date: Mar 2002 Location: Dayton, OH	I have this sometimes, and this may not be your problem, but this is how I fixed my problem. Close the 2nd workbook down and re-open using the Open function in Excel with the first workbook open instead of double-clicking on the file so that they are both open in the same working copy of Excel. __________________ My listening habits Last edited by Butter : 02-01-2011 at 09:39 AM.

02-01-2011, 09:28 AM	#2
Logan Head Coach Join Date: Oct 2000 Location: NYC	Is the one you're trying to move to read-only or otherwise protected?

02-01-2011, 09:59 AM	#5
DaddyTorgo Hall Of Famer Join Date: Oct 2002 Location: Massachusetts	Aaah. That's probably what it is, yeah. I'm big on opening them in separate instances of Excel so I can have them open on two screens and all.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)