Excel 2007 Right-Click Paste option unavailable

  • Thread starter Thread starter KDLange
  • Start date Start date
K

KDLange

I have a user that does not have the option to Paste or Paste Special when
she right-clicks a cell in Excel 2007. She can right-click on a cell and
choose Copy, but when she picks a different cell and right-clicks, the Paste
options are grayed out. If I login to the computer as another user, this
does not happen. Is there aregistry setting I can change for the affected
user, or do I need to create a new user profile on the computer to correct
this issue?
 
Are there any event macros that run? Maybe a selection_change event???

Lots of macros will kill the clipboard.
 
Unable to Paste in Excel, Paste Grayed out

We have had several customers who have lost the ability to PASTE in Excel...

If a user doesnt have the option to PASTE in Excel, do the following:
  1. Close Excel.
  2. Go to C:\Documents and Settings\[userID]\Application Data\Microsoft\Excel
  3. Delete the XLB file.
  4. Open Excel (the XLB file will be recreated - like the normal.dot)
 
This worked for me

This worked for me to recover the small right-click formatting options menu that appears after pasting external data into Excel ... it provides the following right-click options ...
  • "Keep Source Formatting"
  • "Match Destination Formatting"
  • "Create Refreshable Web Query..."
Try this ...
  1. Click on the round main menu button on the top left corner of Excel
  2. Select "Excel Options" from the drop-down menu
  3. Select the "Advanced" button
  4. Scroll down to the "Cut, copy, and paste" section and place a check in all 3 options ... "Show Paste Options buttons", "Show Insert Options buttons" and "Cut, copy and sort inserted objects with their parent cells"
  5. Select "Ok"
If that didn't work, try EricPlatt's suggestion ...
  1. Exit out of all open instances of Excel
  2. Note: the following step may make some of your previously installed add-ons and plug-ins disappear from the Excel Add-Ins ribbon (recover those via "Excel Options > Add-ins > Go ..." and place a check mark in the items you want back, or re-install the add-ins)
  3. Navigate to the "C:\Documents and Settings\username\Application Data\Microsoft\Excel" folder and delete the files named "Excel11.xlb" and "Excel12.xlb" ... these file will be re-created by Excel as necessary ... according to EricPlatt, these files are similar to the "normal.dot" files used by Microsoft Office Word to store user settings
  4. Re-launch Excel
 
EricPlatt said:
We have had several customers who have lost the ability to PASTE in Excel...


If a user doesnt have the option to PASTE in Excel, do the following:
  1. Close Excel.
  2. Go to C:\Documents and Settings\[userID]\Application Data\Microsoft\Excel
  3. Delete the XLB file.
  4. Open Excel (the XLB file will be recreated - like the normal.dot)
Click to expand...
This really helps after days spent in many forums. Thanks a lot, it was great comment:thumb:
 
Back
Top