02-01-2011, 09:26 AM | #1 | ||
Hall Of Famer
Join Date: Oct 2002
Location: Massachusetts
|
Excel - Moving/Copying Sheets program issue
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?
__________________
If I've ever helped you and you'd like to buy me a coffee, or just to say thanks, I have my Bitcoin and Ethereum addressed listed below :) BTC: bc1qykhsfyn9vw4ntqfgr0svj4n9tjdgufryh2pxn5 ETH: 0x2AcdC5cd88EA537063553F5b240073bE067BaCa9 |
||
02-01-2011, 09:28 AM | #2 |
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:39 AM | #3 |
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:46 AM | #4 | |
Hattrick Moderator
Join Date: Jan 2003
Location: Pintendre, Qc, Canada
|
Quote:
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
__________________
A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog... |
|
02-01-2011, 09:59 AM | #5 |
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) | |
Thread Tools | |
|
|