Why are there some SharePoint 2016 list items only visible when the list is exported to Excel and why do they have a different path in the Excel download?

Question

I have a SharePoint 2016 list that has 40 items that are not visible in a list view; however if that view is exported to Excel, those items are visible. The only difference I see is the 40 items missing from List view all have a Path that ends in /item (e.g., SiteName/Lists/NameofList/item). All 11,000+ other items have a path that ends with the name of the list (e.g., SiteName/Lists/NameofList). What is preventing these 40 items from being visible in a list view within SharePoint and only visible when the list view items are exported to Excel, and what is causing the different path?

Answer 1

Hi Anita H, it is a pleasure to be able to help you : )

Per our current research, for the issue some items in the list are not visible, may be due to the following reasons:

1.Check the Read Access setting in list settings- advanced settings. If it is set to read items that were created by the user, then users will be able to see only their own created items. You may need to set read all items option here.

2.Use Item-level permissions. Turn this on under the list's advanced settings. The users will still be able to see items in the list, but only the ones they created themselves.

3.Check the permissions on the items of the list. If all the permissions are requisite, try creating a new view with different name but same options to be shown. Sometimes view gets corrupt and messed up.

4.Change the item-level permissions in the Advanced Settings to Read all items.

5.Check the JSON programming within a list column that is not coded correctly. Go to the column settings for the column that has JSON formatting and review the formula or erase it.

Based on the information provided so far, it is difficult to determine which one is the cause. If possible, would you mind providing some screenshots about the items path "SiteName/Lists/NameofList/item" : ) Since we can't determine what the property you mentioned is. In this way we can do better troubleshooting.

Best Regards.

---

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.