Forum Discussion

mrewenmac's avatar
mrewenmac
Copper Contributor
Oct 19, 2020

Special Paste (Values) not working

Hey guys,

 

I have an issue with paste special where I cannot paste without formatting. 

- this issue only started happening today after using excel for years.

- I have 2 computers on the same office 365 account and the problem does not persist on the other laptop

- I have tried opening excel in safe mode, re-installing, quick repair, rebooting computer... the issue still persists.

- I have already gone to check the following option is selected in the file menu. Go to: File > Options > Advanced.
Under Cut, copy and paste, ensure Show Paste Options button when content is pasted is checked.

 

What I need is to paste cells without formatting or formulas and currently selecting the paste values only will not work.

 

The file type is an excel macro enabled workbook. although this issue persists with the standard microsoft excel worksheet.

 

Any thoughts?

 

Excel
office 365
  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Steel Contributor
    Oct 19, 2020
    It's uncommon phenomenon,,, normally Paste Special works properly and what you are trying can be accomplished using VALUE option,,,better check Microsoft Team for further assistance.
  • Isaac1275's avatar
    Isaac1275
    Copper Contributor
    Oct 10, 2021

    I'm having a similar issue. When I paste formats,  it doesn't work. zeros appear sometimes and circular reference warning appears.

  • weixin22's avatar
    weixin22
    Copper Contributor
    Apr 21, 2022

    mrewenmac 

    Help, I copy the excel information and paste special into the word document. When clicking on the image in the Word I receive this message! May I know how can I solve it?

     

     

  • Thomas_Uhl's avatar
    Thomas_Uhl
    Copper Contributor
    Jul 09, 2022
    Within the last day, when selecting Paste Options in Outlook and Word, the application locks and does not respond. I have tried repairs to Office 365 and have done 2 uninstalls and reinstalls. I have also contacted Microsoft support who escalated to the next support level. I have tried everything I can think of to resolve this problem. Not sure if it was caused with the recent update to Office. Would like to be able to reload the previous version to see if that resolves the issue.
    • SMagan13's avatar
      SMagan13
      Copper Contributor
      Jul 12, 2022

      Thomas_Uhl I went to a previous version and restored and it fixed the issue. Was experiencing the same problem. I was concerned it had something to do with the file being housed on SharePoint but either way restoring to the previous version resolved my issue. 

      • s11hunt's avatar
        s11hunt
        Copper Contributor
        Oct 03, 2023

        SMagan13 

        I am also haveing the same problem. I moved the excel file to sharepoint a while ago and was wodering if that might be the problem but I am quite sure the Paste Special feature worked ok since then.

  • sun241moon's avatar
    sun241moon
    Copper Contributor
    Apr 17, 2023
    The "Paste Special" option may not be available when you copy a row of values in Excel if the cells where you want to paste the values are not compatible with the data type of the copied cells. For example, if you copy a row of values that includes numbers and paste them into a column of cells formatted as text, the "Paste Special" option may not be available. Similarly, if you copy a row of values that includes formulas and try to paste them as values, the "Paste Special" option may not be available.

    What i do is = i copy the data that i want to special paste, and i create a new worksheet in the same excel file and i can special paste in that new excel file.
    And then i cut that data from the new excel sheet and paste it in the original worksheet.

    Hope this helps.

Resources