Quick edit mode doesn't meet users' requirement.  They want the header freezing and column width adjustable like what they did in SharePoint 2010.

I understand the Datasheet view is achieved by Access ActiveX control.  Can this be used in SharePoint 2013? And SharePoint 2013 online?

The datasheet view is available in SharePoint 2013.  I'm sure it is also available with SharePoint Online, but my tenant hasn't been upgraded yet.

Absolutely , the old one datasheet view was far better. Is there any solution on this.

thanks 

CJ

its still there, it's just been renamed Quick Edit and sits under the Library / List tab.

I've just tried this with SharePoint online and the basic functionality works.  Doesn't appear to do the resizing and freeze panes as you did before though.  Are you sure that Excel Services wasn't being