Forum Discussion

Nino0415's avatar
Nino0415
Copper Contributor
Jan 13, 2023

Copy/Cut -> Paste special... turns into something unfamiliar... with Source as starting option!?

Following Dialog Box appears when Paste Special... Source: Paste As: Unicode Text or Text

 

The appearance of Paste special... not only in Excel but also in other Office applications which occurred at once

 

... usually the GUI was as depicted below with many different options:

Paste Special... as it used to appear......

 

The error appears in either Excel or Word, maybe other MS Office applications (not checked) too.

On Office 2016 or Office 365 as well...

What might be the cause of the changed interface?

Of course Office is activated and licensed:

Product Information

14 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    Nino0415 

    This is a clipboard problem. Typically, you'll see the paste as unicode when the clipboard is not gathering the selection properly.

     

    I'd start by opening the clipboard and click copy.  If the clipboard gathers it with the green Excel icon, the paste special will work as intended.  If the icon on the clipboard is a generic white sheet of paper, the clipboard has not gathered it properly.  Clear the clipboard and click Copy until the clipboard gathers the selection properly.  Restart computer, if needed.

     

     

    • Nino0415's avatar
      Nino0415
      Copper Contributor

      Patrick2788

      Thanks for suggestion but it doesn't work at all even after clearing the clipboard
      and restarting PC... Clipboard is cleared several times but there isn't any change or improvement...

       

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        It looks like a few of those selections were copied successfully. Where are you copying from?
    • Nino0415's avatar
      Nino0415
      Copper Contributor
      No. This is the general problem which occurs on several PCs and on any/own excel workbooks/sheets.
      • Paul_Aberdeen's avatar
        Paul_Aberdeen
        Copper Contributor
        Hi

        I receive it when I copy data from a Sage generated sheet sometimes. WHat happens if you just paste, do you then get the chance to use import wizard ? I'd test it, but I'm just not sitting at the right place today

Resources