Forum

Notifications
Clear all

Paste Special not available

10 Posts
4 Users
0 Reactions
79 Views
(@woutervdheeveroutlook-com)
Posts: 4
Active Member
Topic starter
 

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....

 
Posted : 12/12/2023 11:15 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello,

Check if this info at Microsoft Learn is of help.

Br,
Anders

 
Posted : 12/12/2023 5:45 pm
(@keebellah)
Posts: 373
Reputable Member
 

Is the file on your PC read-Only?

 
Posted : 13/12/2023 3:10 am
(@woutervdheeveroutlook-com)
Posts: 4
Active Member
Topic starter
 

No, it is not read only on my PC...

 
Posted : 13/12/2023 4:45 am
(@debaser)
Posts: 837
Member Moderator
 

Is it one particular file or all files?

 
Posted : 13/12/2023 11:52 am
(@woutervdheeveroutlook-com)
Posts: 4
Active Member
Topic starter
 

One particular Excel file...

 
Posted : 14/12/2023 10:11 am
(@debaser)
Posts: 837
Member Moderator
 

Is it only Paste Special, or is Paste also disabled?

 

Also, is it a macro-enabled workbook?

 
Posted : 14/12/2023 11:43 am
(@woutervdheeveroutlook-com)
Posts: 4
Active Member
Topic starter
 

Paste special and paste not available. Yes, macro-enabled.

 
Posted : 15/12/2023 2:45 am
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 15/12/2023 4:22 am
(@debaser)
Posts: 837
Member Moderator
 

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?

 
Posted : 15/12/2023 6:16 am
Share: