Forum Discussion
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
- Patrick2788Silver Contributor
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.
- Nino0415Copper Contributor
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...- Patrick2788Silver ContributorIt looks like a few of those selections were copied successfully. Where are you copying from?
- Paul_AberdeenCopper ContributorAre you copying from a excel sheet that was generated by Sage?
- Nino0415Copper ContributorNo. This is the general problem which occurs on several PCs and on any/own excel workbooks/sheets.
- Paul_AberdeenCopper ContributorHi
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