Share via

Error when copying data from Excel web app into Excel 2013

Anonymous
2015-07-31T20:59:03+00:00

I tried to copy data from the Excel Web App to my desktop Excel 2013. It wasn't a lot of data - 3 columns (of which 2 were mostly blank) x 140 rows. On pasting into Excel, the cell displayed the message, "Retrieving data. Wait a few seconds and try to cut or copy again."

Waiting and then pressing Ctrl-V produced the same result. I tried using Paste Special > Text, but that didn't work either. Any thoughts on a possible solution? Thanks.

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 No comments

Answer accepted by question author

  1. Anonymous
    2017-10-03T14:22:38+00:00

    I found a work around that may work for you. Select [File] [Save As] and then [Download a Copy]. Save to you computer and open with a Desktop version of Excel so you can cut and paste freely.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-10-09T21:15:14+00:00

    Sorry, this is not a work-around; this is simply using Excel desktop version the same old way we used to.

    If I have to do that, there is absolutely no benefit to using Office 360 / Excel Web App online.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-11-24T11:28:46+00:00

    Sorry, this is not a work-around; this is simply using Excel desktop version the same old way we used to.

    If I have to do that, there is absolutely no benefit to using Office 360 / Excel Web App online.

    Completely agree with you. What is the point of having an upgrade (which supposed to be better than a previous version) when we cannot do a simple thing like cut and paste!   This is fundamental stuff Microsoft...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-08-22T21:13:12+00:00

    I have this issue intermittently (randomly, without any pattern).

    It's very annoying!

    It's especially annoying to find out by seeing the error message appear aftertrying to paste (as opposed to seeing the error when I try to copy in the first place).

    If I can't find a solution, this is going to be a show-stopper for me & Office online.

    I'm on a corporate network, so I'm wondering if it might have to do with the persistence of a connection/session?

    Perhaps simply refreshing the browser should fix it?

    I'll try next time it happens...

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-12-08T20:10:26+00:00

    I have had this same issue.

    The only way i have found to get around this is to go back to the source document, un-select everything, then re-highlight the section and copy again.

    Cheers

    Was this answer helpful?

    0 comments No comments