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

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.
mel200Asked:
Who is Participating?
 
redmondbCommented:
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
 
redmondbCommented:
Hi, mel200,

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

Regards,
Brian.
0
 
mel200Author Commented:
Thanks for your fast help! how could I check that?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
redmondbCommented:
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
 
redmondbCommented:
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
 
mel200Author Commented:
Ok, I see Book1. I've clicked  on it and it's open.
0
 
redmondbCommented:
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
 
mel200Author Commented:
OK- no macros.
0
 
redmondbCommented:
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
 
redmondbCommented:
Oops. VBE
0
 
mel200Author Commented:
screenshot of names
I've attached an image screenshot of names.
0
 
redmondbCommented:
Mel,

Thanks. I'm afraid that disproves my theory.

Let me do some googling.

Regards,
Brian.
0
 
redmondbCommented:
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
 
mel200Author Commented:
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
 
redmondbCommented:
Mel,

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

Regards,
Brian.
0
 
mel200Author Commented:
Just from my start menu, I have it pinned there. Thanks.
0
 
redmondbCommented:
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
 
mel200Author Commented:
Sure here it is. :)

 capture
0
 
mel200Author Commented:
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
 
redmondbCommented:
Mel,

Thanks for keeping me posted.

All the best tomorrow,
Brian.
0
 
mel200Author Commented:
Adobe Contribute Plugin!! You're a genius!
0
 
redmondbCommented:
Mel,

Excellent!

Thanks and all the best,
Brian.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.