Forum Discussion
Nino0415
Jan 13, 2023Copper Contributor
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 ... usually the GUI was as depicted below with many different options: The error a...
Patrick2788
Jan 16, 2023Silver 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.
- Nino0415Jan 17, 2023Copper 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...- Patrick2788Jan 17, 2023Silver ContributorIt looks like a few of those selections were copied successfully. Where are you copying from?
- Nino0415Jan 18, 2023Copper Contributor... they are copied from an opened Excel sheet selected cells filled with content formatted as General!
But, fortunately today in the morning I've tried again on the same Excel worksheet and the result was as expected.
What might happen that things went bad/wrong for some time? Despite trying to correct it,
nothing could cure bad behaviour. And then suddenly, everything comes back to normal again!?
There isn't any explanation of the problem except some wizard(wizardry) from the background... 🙂