Why would "paste special" disappear as an option in Excel

[JI]

I'm trying to copy a graph from a working spreadsheet into another workbook
and I just want to paste it as a bitmap. However, "Paste Special" is grayed
out. What would cause that and can I fix it?

 

[ShaneDevenshire]

Hi,

Why - because that's the way Microsft programmed it.

Workarounds -
1. Hold down the Shift or Ctrl key and select the chart, copy it, move to
the other file and choose Edit, Paste Special. (bit map is not an option
but this may be satisfactory.
2. Select the chart normally and THEN hold down the Shift key and open the
Edit menu. Choose the command Copy Picture and pick your desired options.
Move to the other file and paste. No need for Paste Special in this case.


If this help please click the Yes button.