Solved

My Excel 2010 Paste Options have Disappeared

Posted on 2012-03-16
17
2,915 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 125 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 125 total points
ID: 37730365
0
 
LVL 16

Assisted Solution

by:R. Andrew Koffron
R. Andrew Koffron earned 125 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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 41

Assisted Solution

by:dlmille
dlmille earned 125 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

706 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

11 Experts available now in Live!

Get 1:1 Help Now