I can't copy from Grid View in SharePoint list Online

Aris Gkintonis 25 Reputation points
2023-10-25T08:41:53.7766667+00:00

Hello team,

I have an online SharePoint list.
The goal is to copy some items from that list (the whole rows) and paste them into an Excel sheet on my Desktop.
So, I chose "Edit in Grid View".
Then I select one Item by choosing the bullet on the left side of the row.
User's image

Normally, If I push Ctrl+C, the marked purple line should be dashed, showing me that the item has been copied.

**
But that does not happen.**

  • Sometimes if I choose one more item (for example Item 2476), and I push Ctrl+C, it works. (some other times this method doesn't work)
  • After 5 minutes it may work with no changes in the list settings or the browser
  • This happens on multiple computers around Europe and on different lists.
  • I've tried both Chrome and Edge
  • I cannot find a pattern on when this works/doesn't work
  • This issue started when the new user interface was implemented on Sharepoint lists.
  • Also, I cannot find the "Add new item" last row on Grid View. (I assumed it was removed in the new UI?)

Thanks for reading my issue. Any help will be much appreciated :)

Regards,

Aris

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,011 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ling Zhou_MSFT 14,450 Reputation points Microsoft Vendor
    2023-10-26T02:31:57.5133333+00:00

    Hi @Aris Gkintonis,

    Thank you for posting in this community.

    My coworker and I tested copying items with shortcuts in grid view, but we were all able to do it properly.

    We need to work together to narrow down and resolve the situation. So, please kindly provide more information below to let us work further.

    1.Whether all SharePoint lists have the same problem? You could create a new SharePoint list to check.

    2.Check if the same issue occurs with other SharePoint site collections.

    3.Convert the list to classic mode and then see if the problem persists.

    I actually learned that shortcuts work on classic experience (But it actually works in the modern experience in testing as well). You can change the experience to classic. If you still want to use modern experience, then you can try exporting the data to excel and copying the contents of excel. This also solves the problem of shortcuts not being able to copy multiple items at the same time.

    Export to Excel from SharePoint or Lists

    User's image

    It is much easier to manipulate items in an excel file.

    User's image

    Also adding new item is visible in my grid view.

    First, you need to make sure that you have Contribute permission level or higher for the list and that your permission to add items is not disabled. Please check your permission level on the list by going to List Settings > Permissions for this list > Check Permissions and entering your name or email address.

    Second, you can check in other lists or site collections to see if the problem still exists. If it still exists, please send me a screenshot of the list, it might better help me analyze the problem.

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful