Forum Discussion

4kchitsend's avatar
4kchitsend
Copper Contributor
Jul 26, 2018
Solved

Copy/paste no longer working completely in Excel

I can no longer copy & paste from Excel 2016 to Word 2016.  Nor paste onto Outlook 2016.  This just started acting up 2 days ago.  I can paste only as a photo or as text only.  I can copy and paste fine in Excel to Excel. In Word to Word.  In Outlook to Outlook.  Just not from Excel to others unless I paste as a photo.  Any suggestions?

 

This is my first time posting to a forum.  I apologize if I have repeated myself.  My post does not seem to be appearing.

 

Thanks,

  • 4kchitsend - try upgrading the files. In Excel, click on the File menu, then Upgrade, or update or something. I don't have an XLS file around to see what the exact menu item is. 

     

    Then for grins, save it, close excel, and reopen. Does that fix it?

6 Replies

  • Ed Hansberry's avatar
    Ed Hansberry
    Bronze Contributor
    1. Reboot. Ensure that nothing wonky is wrong with Windows and the clipboard.
    2. Repair Office quickly. In Add/Remove programs is Office and an option to do a quick repair. Probably have a "change" button or something to see it.
    3. Do a full repair of office (same as above, different checkbox) which takes long.
    4. Worst case, uninstall, use the Office Cleanup utility from https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8 then reinstall Office after rebooting.
    • 4kchitsend's avatar
      4kchitsend
      Copper Contributor

      Tried the quick repair to no avail.

      I opened a new Excel sheet and it copies and pastes into Word just fine.  But multiple Excel files are not copying properly.  Most were generated from Excel 1997 (a couple of computers ago) and whenever saving, a compatibility screen would pop up.  I simply copy and paste onto a new spread sheet.  I'm hoping I don't need to start over and create new originals.  It is as if I clicked on a wrong item which only permits pasting as a photo or text.

      • Ed Hansberry's avatar
        Ed Hansberry
        Bronze Contributor

        4kchitsend - try upgrading the files. In Excel, click on the File menu, then Upgrade, or update or something. I don't have an XLS file around to see what the exact menu item is. 

         

        Then for grins, save it, close excel, and reopen. Does that fix it?

Resources