?
Solved

My Excel 2010 Paste Options have Disappeared

Posted on 2012-03-16
17
Medium Priority
?
5,381 Views
Last Modified: 2012-03-26
My paste options have disappeared in Excel 2010.  My laptop crashed earlier this week.  I just finished re-installing Windows 7, clean installation.  I re-installed Office 2010 and started working on a simple spreadsheet from the default spreadsheet.  I started a column for numbering the lines.  Instead of fill, I just started the column with 1, =1+A1 on the next line and then I normally just copy the formula down as far as I need to.  But, when I paste, the only option to paste is “Keep Text Only”.  Normally there are a dozen options.  I read some threads, tried the registry change, tried the reset to defaults, but I still did not have paste options.  So, I did an Office repair.  I opened that spreadsheet this morning, tried copy and it worked, for a while.  I can no longer paste formulas in this spreadsheet.  I tried a default spreadsheet, but paste does not work.  I tried an old legacy spreadsheet thinking there may be something I did to the spreadsheet, but paste does not work on the legacy spreadsheet either.  Our customizations include font, template location, default save location and some quick access bar changes.  I did not have this problem before the crash.  I will greatly appreciate any help you can give me!  I am trying to assemble tax information!  Thanks!
0
Comment
Question by:Jebidieh
17 Comments
 
LVL 6

Expert Comment

by:vmagan
ID: 37730345
please post a screen shot
0
 
LVL 6

Assisted Solution

by:bluemeln
bluemeln earned 250 total points
ID: 37730357
The option to copy should be available. If it is not your template that's messed up, and Office repair did not catch it, I would go straight to uninstalling, rebooting, and reinstalling.

Do these same problems occur when you start Excel in Safe Mode?
Start>Run
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
Or Excel.exe /Safe
0
 
LVL 6

Assisted Solution

by:vmagan
vmagan earned 250 total points
ID: 37730365
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Assisted Solution

by:R. Andrew Koffron
R. Andrew Koffron earned 250 total points
ID: 37730382
To add to bluemeln's comment, if the problems go away when you start Excel in Safe Mode, turn off all add-ins. Close Excel and open in normal mode. If the problems are gone, an add-in is causing them. Now add them back on one by one until you have found the offending add-in (source: http://www.pcreview.co.uk/forums/cant-copy-and-paste-paste-special-between-excel-workbooks-t1064531.html).
0
 

Author Comment

by:Jebidieh
ID: 37730423
Thanks for your input.  I tried using Excel in safe mode, but the paste options do not work in safe mode either.  I should have mentioned earlier that the Advanced Options for Cut, Paste and Copy are all checked.

I attached two screenshots showing the paste options.

Thanks again for your help!
0
 

Author Comment

by:Jebidieh
ID: 37730426
I just learned that the paste options are not working in Word either.
0
 

Author Comment

by:Jebidieh
ID: 37730474
I tried checking Excel Add Ins in and then checking them back out.  The Paste options still do not work.
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37730476
Where are the screenshots?
0
 

Author Comment

by:Jebidieh
ID: 37730515
I thought that I had attached them to the post a few back.  Let's see if I can include them here:

I tried doing a printscreen and then paste them here, but it did not work.  I will try to attach them again.

Thanks!
Screenshots-of-Paste-Options.pdf
0
 

Author Comment

by:Jebidieh
ID: 37730537
Ok.  I was reading something a while back that indicated that Java may be causing a problem different from mine, but paste related.  So.  I uninstalled Java, did not re-start the computer, opened both Word and Excel and paste now has all of the familiar options.

What is going on?

As always, thank you so much for your help!
0
 

Author Comment

by:Jebidieh
ID: 37730552
But, as soon as I opened the spreadsheet that I was working on, the Paste options stop working.  Now when I open Word and Excel, even for blank spreadsheets and blank documents, the paste options no longer work.  Frustrated.  Hoped to get this done today.
0
 

Author Comment

by:Jebidieh
ID: 37730616
I am still not sure what is going on, but I re-started my computer.  I opened Excel and the paste options worked in the default spreadsheet.  I opened Word and the paste options worked.  So, I copied the information from the spreadsheet I was working on to the default spreadsheet and so far, the paste options are still working.  I would love to know what happened.  What can you do in a spreadsheet that would affect the paste options in other Microsoft products?

Thanks again for your input!
0
 

Author Comment

by:Jebidieh
ID: 37730714
And now the paste options have stopped working again.  Grrrrrrr.
0
 
LVL 42

Assisted Solution

by:dlmille
dlmille earned 250 total points
ID: 37731828
On the offchance you ran some code or some add in did that seconded your controls/repurposed them (which I've done so I needed to figure how to reset everything)...  Not sure this is the fix if its happening in other Office apps, but nothing ventured, nothing gained!

This code will reset all the ribbon controls in Excel 2010.  You may be missing an options because some control was seconded by another code snippet.  RemoveControls removes any that were created by other code (it won't mess up your default ribbon) and ResetControls should set them back to their original purpose if any had been repurposed).

Give this a shot:

Sub removeControls()
Dim lngId As Long
Dim CtrlCbc As Object
Dim CtrlCbcRet As CommandBarControls
Dim arrIdNum As Variant

On Error Resume Next

    Set CtrlCbcRet = CommandBars.FindControls
    For Each CtrlCbc In CtrlCbcRet
        CtrlCbc.Delete
    Next CtrlCbc
    
End Sub
Sub resetControls()
Dim ctrl As Object

    On Error Resume Next
    For Each ctrl In Application.CommandBars
        ctrl.Reset
    Next ctrl

End Sub

Open in new window

0
 

Author Comment

by:Jebidieh
ID: 37742138
I tried dlmille's code.  I cannot promise that I completed it correctly.  I am a newbie to VBA.  But what I did, did not work.  I needed to get some work done, so I uninstalled Office 2010.  I restarted the machine.  Then I ran a CCleaner scan and then registry cleaner.  I re-installed Office 2010 and Excel started working again.  Until today!  I opened a timesheet that I had updated when I was having difficulty.  Again, I lost all but the "Keep Text Only" paste option.  Then I realized that when I hold Cntl + C for a second, the copy function seems to toggle.  In one case, when I copy, the dashed box comes up and I have all paste options.  If I hit Cntl + C again, I will get a solid box around the cell and I have only the "Keep Text Only" paste option.  It toggles between those options.  If this is an option, I did not know about it.  We cannot get another machine in the building to repeat that behaviour.  Does anyone know if there is check box option that I checked to get this option or if there is another program that made the option available?

Thanks for everyone's help.  I will award points after I receive input about this comment.
0
 

Accepted Solution

by:
Jebidieh earned 0 total points
ID: 37750191
Hi Folks!

There are several threads running on the Microsoft Office Answers forum that have identified problems with IE9 and several other browsers that create this problem.  If the browsers are closed, the clipboard options are restored.  I have not found a resolution yet, but evidently Microsoft is aware of the problem at this point.

Here is one of the threads:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/problem-with-copy-paste-in-excel-2010/cca7eb06-4815-4d3b-a9c1-08f0ddecf0a2

Thanks again for everyone's help!

Jebidieh
0
 

Author Closing Comment

by:Jebidieh
ID: 37764986
I found the "known problem" on the Microsoft Office Answers forum.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

840 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