If I copy a section in a file, Paste Special is not available, regardless if I right click or use Ctrl-V. On someone else's PC they can paste. Just on mine not....
Is the file on your PC read-Only?
No, it is not read only on my PC...
Is it one particular file or all files?
One particular Excel file...
Is it only Paste Special, or is Paste also disabled?
Also, is it a macro-enabled workbook?
Paste special and paste not available. Yes, macro-enabled.
Is there a macro that clears the clipboard or something similar.
If there is nothing to past then these options are not available or greyed out
Maybe an AddIn that is loaded oyour system that causes this
Perhaps you have event code such as a Worksheet_SelectionChange routine that is preventing it. (it may be deliberate) Is it your workbook, or did someone else make it?