Excel 2007 Right-Click Paste option unavailable

[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?

 

[Dave Peterson]

Does that user use EssBase?

If yes...

I don't use it, but Nigel posted this:

http://groups.google.co.uk/group/mi...32693214bf7?lnk=st&q=&rnum=1#0668432693214bf7
or
http://snipr.com/1nul6

===This is snipped from his post===

Go to the essbase menu and select options

Go to the global tab and deselect enable Secondary Button and enable Double
clicking

select OK

Essbase Hijacks those function, to reset it for essbase use, do the opposite
of above.

 

[KDLange]

No, sorry. We do not use any EssBase add-ins.
Still looking...

 

[Dave Peterson]

Are there any event macros that run? Maybe a selection_change event???

Lots of macros will kill the clipboard.

 

[EricPlatt]

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)

 

[magickingdl]

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

 

[nerminhano]

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 really helps after days spent in many forums. Thanks a lot, it was great comment