Solved

Paste Options Missing Word, Excel

Posted on 2011-02-26
5
1,855 Views
Last Modified: 2012-06-22
Hello Everyone

Something strange has happened.

I no longer get the usual Paste Special Options when trying to Paste an image into Word or Excel.

The only options given to me in Word are   ...  Paste Specail As 'files' OR 'Package Object'.

In the past, I could Paste an image as a JPG, GIF or PNG.

Not any more!

In Excel, no Paste is even possible. the Paste Button stays dimmed folloying a COPY operation from a different program.

Any ideas?
0
Comment
Question by:KarlTheHopeless
  • 2
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
Raheman M. Abdul earned 400 total points
ID: 34986649
Following this: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_22643178.html?sfQueryTermInfo=1+10+30+appear+excel+option+past

1. choose View->Toolbars->Customize and select the Worksheet Menu Bar on the Toolbars tab and press Reset, are they re-enabled when you copy something?


2. It would appear that something has disabled the controls in code. Try this:
    1. Press Alt+f11 to open the VB Editor
    2. Press Ctrl+G to go to the immediate window
    3. Type this:
         Application.Commandbars("Cell").Reset
         and press enter.
     4. Close the VB Editor and see if the problem is fixed.
0
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 400 total points
ID: 34986667
Referring to: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_25203727.html?sfQueryTermInfo=1+10+30+applic+excel+reset

Note: if you have a lot of toolbar customisations, make a copy of your xlb file first and store it somewhere safe!
 
You can edit the registry (make a backup first!) and delete the Options hive at:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel
(where the 11.0 is your version - 10 for OfficeXP, 11 for 2003 and so on)
Make sure Excel is closed first. The key will be recreated when you start Excel again

0
 

Author Comment

by:KarlTheHopeless
ID: 34986678
Hello Marahman

No lick, I'm afraid.

It is not just Excel and Word that are behaving oddly, but Coreldraw too.

When my Office Clipboard is open - I get the message ...

"Item not collected: Format not supported by Office Clipboard."


Everything has been working fine for months; so something has happened very recently, but I have no idea what.

I've scanned the computer. System Restored back to when it WAS working - but still no good!
0
 
LVL 80

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 100 total points
ID: 34992395
well I guess we are left with: control panel / programs and features / microsoft office and then select repair
0
 

Author Comment

by:KarlTheHopeless
ID: 35122717
Hi Guys

Well, I never solved the problem; but I did discover that a recent Microsoft update changed the way in which images are being handled by Windows.

I guess I will just have to live with it.

However, a program called Mystic Thumbs has made life easier - sepcially for dealing with WMF files.

Karl
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

756 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