Fix SharePoint Quick Edit When List Items Disappear in a Web Part
Question details
The user needs to stop SharePoint list items from disappearing when using Quick Edit in an embedded list web part.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A SharePoint list is embedded in a web part and edited using Quick Edit, also called grid view.
- Observed behavior
- List items disappear during Quick Edit in the web part, but editing works on the list's own page.
Open the list directly and test Quick Edit, then test the same view in the web part to confirm where the issue occurs. Note the column types, especially lookup columns, and whether data was recently pasted into the grid.
Create and test a new SharePoint list view
Use a new view to check whether the view used by the web part is causing the issue.
Open the list's own page, select the view menu, and choose Create new view. Give the view a distinct name.
Use the view menu and column controls to match the original view's displayed columns, sorting, filtering, and grouping as closely as possible. Save the view.
Open the page containing the list web part, select Edit, and open the web part's edit controls. Select the new view, then save or publish the page.
In the list web part, select Edit in grid view or Quick Edit and check whether the items remain visible.
Rebuild the SharePoint list and test columns gradually
Use this approach when a new view does not resolve the problem and the list or one of its columns may be corrupted.
Work with Exported SharePoint List Data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing exported list data and other documents. Its Microsoft Office format compatibility makes it easy to move existing files into WPS. It does not repair SharePoint Quick Edit or replace a SharePoint list web part.
Frequently Asked Questions
Why do items disappear in the web part but not on the list page?
The web part's selected view, the list data, or a column may be contributing to the issue. Create a new view from the list's view menu and select it in the web part's edit controls to test the view.
What if a new view does not fix Quick Edit?
Create a blank replacement list through New > List, then add columns and items in stages. Test Edit in grid view in a List web part after each group to help identify the cause.
Can lookup columns or pasted data cause this problem?
They can contribute to the issue. When rebuilding the list, recreate lookup columns with the correct source lists and test representative values before adding more data.
Is Quick Edit the same as Edit in grid view?
Quick Edit is the older name for the grid editing experience. Depending on the SharePoint interface, the command may appear as Quick Edit or Edit in grid view.
