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.
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.
ASKER
Thanks for your fast help! how could I check that?
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.
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.
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.
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.
ASKER
Ok, I see Book1. I've clicked on it and it's open.
Mel,
OK. Click on Cancel and then Alt-F8, please. This will display a list of any macros (please see attached).
Thanks,
Brian
OK. Click on Cancel and then Alt-F8, please. This will display a list of any macros (please see attached).
Thanks,
Brian
ASKER
OK- no macros.
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.
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.
Oops. 
ASKER
I've attached an image screenshot of names.
Mel,
Thanks. I'm afraid that disproves my theory.
Let me do some googling.
Regards,
Brian.
Thanks. I'm afraid that disproves my theory.
Let me do some googling.
Regards,
Brian.
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.
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.
ASKER
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.
-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.
Mel,
Thanks. I'm going to try the same sequence - how do you start Excel?
Regards,
Brian.
Thanks. I'm going to try the same sequence - how do you start Excel?
Regards,
Brian.
ASKER
Just from my start menu, I have it pinned there. Thanks.
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.
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.
ASKER
Sure here it is. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
Mel,
Thanks for keeping me posted.
All the best tomorrow,
Brian.
Thanks for keeping me posted.
All the best tomorrow,
Brian.
ASKER
Adobe Contribute Plugin!! You're a genius!
Mel,
Excellent!
Thanks and all the best,
Brian.
Excellent!
Thanks and all the best,
Brian.
Is it possible that you have an Auto_Open macro in your Personal.xls? which clears the clipboard?
Regards,
Brian.