Share via

Power Query in Excel Error - There's a problem with the clipboard, but you can still paste your content within this workbook.

Anonymous
2021-04-07T15:35:44+00:00

I have one file that was previously working, but now repeatedly gives me this error message when I click Refresh All

When the message pops up, there is data on the clipboard which I can paste into NotePad - it looks like the entire column of data on a couple of columns - mostly one date column but it changes at least once between error messages.

When would Power Query move any data onto the Clipboard? Is this intended behaviour in some scenario!?

According to my Company Portal I have the latest version of the "Microsoft 365 Apps for enterprise" installed Version 2008 (Build 13127.21348 Click-to-Run)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-04-12T13:03:17+00:00

    Hi Jon,

    Haven't hear from you for a while, please feel free to post back when you have time.

    We will keep monitoring on this thread.

    Regards,

    Alex Chen

    0 comments
  2. Anonymous
    2021-04-20T10:44:02+00:00

    Hey Alex, 

    Apologies, I thought I'd responded already. 

    Yes, both SafeMode and disabling the Microsoft Azure Information Protection COM Add-in have removed the error.

    Jon

    4 people found this answer helpful.
    0 comments