Solved

Copy/paste doesn't work when I open new document in Ecel

Posted on 2011-09-28
22
254 Views
Last Modified: 2012-05-12
On office 2007, with my Dell N7010, on Windows 7.

Since I got this laptop, I've noticed that if I copy and paste something, THEN open excel, the clipboard doesn't retain the information.

Example: I copy a name from an email. Then I open Excel. I can't paste it, the clipboard is empty. I have to copy the information again.

Example 2: I copy information from a website. Then I open Excel. I can't paste it, the clipboard is empty. I have to copy the information again.

I may have more examples with other programs, but this one for sure happens every time. Thanks.
0
Comment
Question by:mel200
  • 13
  • 9
22 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 36718754
Hi, mel200,

Is it possible that you have an Auto_Open macro in your Personal.xls? which clears the clipboard?

Regards,
Brian.
0
 

Author Comment

by:mel200
ID: 36718767
Thanks for your fast help! how could I check that?
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36718974
Mel,

I'm assuming you're not comfortable editing (or at least looking at) at macros, so let's start with a quick check as to whether or not you have a Personal.xlsm ( or .xlsb or .xls).

In Excel, hit Alt-W to display the View Ribbon. If the Unhide button is enabled, click on it. At least one spreadsheet will be listed - let me know the name(s).

Thanks,
Brian.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36719025
Mel,

I'm on Excel 2010, so my instructions above should be OK for 2007, but just in case, I've attached a screenshot.

Regards,
Brian.  
Unhide
0
 

Author Comment

by:mel200
ID: 36719111
Ok, I see Book1. I've clicked  on it and it's open.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36719177
Mel,

OK. Click on Cancel and then Alt-F8, please. This will display a list of any macros (please see attached).

Thanks,
Brian
 Macro
0
 

Author Comment

by:mel200
ID: 36719245
OK- no macros.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36719313
Mel,

OK, click Cancel, please.

Next possibility is an add-in. Alt-F11 brings up the Visual Basic Editor. Please let me know if there are any names on the left hand side (please see attached).

Thanks,
Brian.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36719327
Oops. VBE
0
 

Author Comment

by:mel200
ID: 36719549
screenshot of names
I've attached an image screenshot of names.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36719814
Mel,

Thanks. I'm afraid that disproves my theory.

Let me do some googling.

Regards,
Brian.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 26

Expert Comment

by:redmondb
ID: 36719859
Mel,

Oh, another thought first. It's notoriously easy to clear the clipboard in Excel (e.g. simply updating a cell). Could you give me your exact sequence of actions from copying in Outlook to realizing that the clipboard is empty.

Also, how long has this problem been happening?

Thanks,
Brian.
0
 

Author Comment

by:mel200
ID: 36719955
It's been happening since I got the laptop, last January. Sequence of actions:

-With Excel closed, I copy text from an email. (highlight and CTRL-C, or right-click and COPY)
- I open Excel.
-I click in a cell and click CTRL-V. Or I right-click to paste, but paste is greyed out.
- I can't paste it, the clipboard is empty. I have to copy the information again.(I've tried viewing the clipboard, and it is empty at this point.)

This happens every time.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36720044
Mel,

Thanks. I'm going to try the same sequence - how do you start Excel?

Regards,
Brian.
0
 

Author Comment

by:mel200
ID: 36720640
Just from my start menu, I have it pinned there. Thanks.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36725978
Mel,

Sorry for the delay - I was digging out Excel 2007.

It works fine for me.

There's one last thing I can think of to try (see attached)...
Click on the Orb. Click on "Excel Options". Click on "Add-Ins". Screen capture the details and post it.

Thanks,
Brian.

 Options_1 Options_2
0
 

Author Comment

by:mel200
ID: 36732192
Sure here it is. :)

 capture
0
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
ID: 36748852
Mel,

Thanks, that's encouraging. Any of those COM Add-Ins could be the source of the problem.

I know you mentioned that the problem occurred whether you used either Outlook or your browser but I'd like to keep this as simple as possible, so could you check that it also happens when you copy from NotePad? If it does, then use that for the following. If it doesn't then let me know before doing anything else (as it's possible that the problem isn't Excel).

OK, assuming the problem happens with NotePad...

So far, we've haven't updated anything but that's going to change now - teeth brushed, seatbelt on and backups up to date?!

At the bottom of the Options' Add-Ins tab click on the drop-down and change it from "Excel Add-Ins" to "COM Add-Ins" and click on "Go" (please see attached).

Another dialogue is displayed listing the COM Add-Ins with a check box beside each one. Untick one of the ticked Add-Ins and click on "OK" (start with the Google one). Shut down Excel and re-test. If that doesn't fix it, repeat the process until the problem goes away or all of the Add-Ins are unselected.

Fingers crossed,
Brian.
Options_3
0
 

Author Comment

by:mel200
ID: 36761706
OK, thanks, Brian. It does happen with notepad. I don't feel quite ready to do that tonight, so will attack it tomorrow morning when my mind is fresher. Thanks for all your help!
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36762945
Mel,

Thanks for keeping me posted.

All the best tomorrow,
Brian.
0
 

Author Closing Comment

by:mel200
ID: 36818969
Adobe Contribute Plugin!! You're a genius!
0
 
LVL 26

Expert Comment

by:redmondb
ID: 36890989
Mel,

Excellent!

Thanks and all the best,
Brian.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now