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:


Free Windows Admin Tool Kit Click here and download it now
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?
Free Windows Admin Tool Kit Click here and download it now
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?

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.

Free Windows Admin Tool Kit Click here and download it now
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.
Free Windows Admin Tool Kit Click here and download it now
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.  :(

Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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/

March 9th, 2014 4:35pm

That setting was currently correct ... still greyed out

Free Windows Admin Tool Kit Click here and download it now
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!
Free Windows Admin Tool Kit Click here and download it now
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.

Free Windows Admin Tool Kit Click here and download it now
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!
Free Windows Admin Tool Kit Click here and download it now
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!
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2015 6:07pm

Not working for me. It's already ticked.
May 21st, 2015 3:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics