Quick Edit Greyed out in Custom List
I have set up a SP 2013 environment using the trial software. I have created a new custom list using the
Custom List App. I've created all the columns and I just want to use Quick Edit to be able to cut and paste columns from an excel sheet (I'd prefer to import the excel sheet but that icon is missing!). Unfortunately, this is greyed out.
Just to test further, I created another custom list using the Custom List in DataSheet View
App - I can use Quick Edit in this list.
Is there a way to enable Quick Edit in my original list..? I don't want to recreate all the columns again - there are quite a few.
Thanks
April 3rd, 2013 12:56am
Same problem here. Just upgraded our SharePoint 365 site online.
One of our lists does not show the options above the list that allows you to select views and add or edit items.
Moreover the Quick edit button for this list is greyed out.
Please help as this is very annoying.
Dirk
Here's a screenshot of a list that works fine:
Here's a screenshot from a list that show the problem behaviour:
-
Edited by
DirkL
Wednesday, April 03, 2013 10:58 AM
-
Marked as answer by
Jack-GaoMicrosoft contingent staff, Moderator
Thursday, April 11, 2013 12:55 PM
-
Unmarked as answer by
Trevor SewardMicrosoft contingent staff, Moderator
Tuesday, October 01, 2013 5:06 PM
April 3rd, 2013 10:58am
I see this has been marked as an Answer but the above does not provide a reason or solution. Jack-Gao, can you please provide some further information. Thanks.
April 11th, 2013 11:30pm
Has anyone found a solution for this?
April 22nd, 2013 4:36pm
I'm using SharePoint 2013 Foundation but this worked for me.
I had created a custom list and made it a template. I then found the issue your describing. After faffing with permissions and trying things I did to create the list reversed and taken out 1 by 1 I found its all about the checkboxes.
You have to enable check boxes.
List settings > (Under Views heading) All Items > Tabular View > Allow individual item checkboxes (Tick this box).
> CLICK OK <
Now you should have the ability to edit using quick edit. Hope this helps you out?
-
Proposed as answer by
_jam
Wednesday, April 24, 2013 10:23 AM
-
Marked as answer by
Margriet BruggemanMVP, Moderator
Thursday, April 10, 2014 7:04 PM
April 24th, 2013 9:10am
Hi iam,
I am trying to find in my list where you are referring to "Tabular View" but I can't see anything under the List tab or under Views.
What I did do though, was create a new View. I just created it using "Standard View". Now, I am able to change to
Quick Edit, and I can now also see the search field for the list and the
Edit link. iam - maybe this is what you are referring to.
Not sure why, but for some reason, the default "All Items" view that is created when you create the list does not allow the
Quick Edit or the Find an Item search field.
Hopefully this helps someone else.
-
Proposed as answer by
Christopher W. Douglas
Thursday, May 29, 2014 10:16 PM
April 29th, 2013 12:22am
Hi Kelsnz,
If you go to your list in question.
Click on lists from the ribbon and select list settings.
Scroll down towards the bottom and you will see Views heading. Click on All Items.
If you scroll down the list I have a subheading called Tabular view.
>Name
>Columns
>Sort
>Filter
> Tabular view
If you expand this tree out you will hopefully see the option allowing you to tick the Allow individual item checkboxes. Tick the box and your away.
I'm using SP2013 Foundation and SP Online and both have the option I describe.
I hope this helps clarify the position?
Regards
jam
May 2nd, 2013 10:59am
I found that turning off any grouping in the view fixes the problem as well.
May 10th, 2013 8:16pm
Jim, you're the one! Thanks!
August 2nd, 2013 6:11pm
Checking the Allow individual item checkboxes did not fix my issue. The only thing that worked was removing the Group By selection. Frustrating for something to work fine in 2010 only to stop working in 2013. :(
August 19th, 2013 6:30pm
Another option is that custom XSL in the view seems to be preventing Quick Edit and the view menus from appearing. I'm still looking into this but if anyone is still stuck, it's another place to look.
October 1st, 2013 3:15pm
My list wasn't in group when I had this issue, but this worked for me:
Modify View-> Style->under View Style select Default(mine was on shaded before)
Hope this helps
-
Proposed as answer by
Richard Duffy
Monday, March 03, 2014 1:37 PM
February 10th, 2014 2:22pm
I have similar problem on list that was upgraded from SP2010 template. I found working solution by applying 'clienttemplates.js' value to jslink property in my view. This property is new to SP2013 so it was not existing in my old list template. SP2010 is
ignoring this property so you can include it Schema.xml to have it working for both versions.
You can also edit view webpart and update jslink property manually.
All credits belong to this post
http://www.rickvanrousselt.com/updating/
-
Proposed as answer by
Lukasz Dudziak
Sunday, March 09, 2014 4:35 PM
March 9th, 2014 4:35pm
That setting was currently correct ... still greyed out
March 26th, 2014 7:22pm
I didn't have any grouping on the list and it still greyed out... that may have an impact on it but it isn't the silver bullet that fixes this with those who have upgraded.
March 26th, 2014 7:24pm
I also had this issue. I changed to Shaded and the Quick edit disappears. Changed it back to default and it now appears. How silly! I am also not liking how the Quick edit will only list as many as you set your view up to list. Show me all of them!
March 26th, 2014 7:40pm
This has to do with 'groups'. The list you are having problems with, is probably grouped. If it's not grouped the "edit" and "quick edit" should show up. If it's grouped it doesn't, because the 'group' would kill the bulk edit.
Worked for me anyways.
Good luck!
April 8th, 2014 8:52pm
I have the same problem, with a custom list imported from a SharePoint 2010 site.
This is what is SUPPOSED to work. Yes, you have to enable checkboxes for Quick Edit to work. However, the solution by kelsnz worked for me: Just create a new view using "Standard View". The imported view will not allow Quick Edit, and none of these suggestions
will correct an IMPORTED view.
May 29th, 2014 10:22pm
I ran into this problem as well and none of the listed items helped me. Even creating a new view did not work. What I discovered was that my XML View definition was missing "<JSLink>clienttemplates.js</JSLink>". I added this to an existing
view using SharePoint designer and now Quick Edit works as expected.
August 14th, 2014 3:53pm
This can occur when columns are defined as Multiple Line Text fields with Rich or enhanced Rich Text. Change those to plain text!
September 23rd, 2014 10:22pm
I'm late to the game on this, but I just encountered the same issue. SP Foundation 2013 demo in a VM. Simple, four-column list. Nothing fancy. I have the box checked to 'Allow individual item checkboxes.
The important variable for me is that I set the view to display Newsletter style. That's what's causing the Quick Edit box to gray out (apparently, any choice other than Default causes this).
I found a resolution at https://support.microsoft.com/kb/2876824?wa=wsignin1.0 . Eventhough that page talks about SP Online, the proposed fix works on SPF also. Click
the List tab on the ribbon for your list. Then, click Modify View. Scroll down and click on the plus sign next to Style to expand that section. From the 'View Style' choices, select Default.
October 22nd, 2014 3:24pm
just wanted to say thanks for this answer. i was going crazy trying to figure this out and this was exactly what i needed to do. thanks!
March 19th, 2015 6:07pm
Not working for me. It's already ticked.
May 21st, 2015 3:48am