Contents
Is the list displayed in datasheet view?
I have two SharePoint Enterprise 2010 sites in two different farms. Both sites I am accessing with my local browser IE 10 (32-bit). List1 in Site1 can be opened in DataSheet view but List2 in Site2 cannot be opened in DataSheet view. I have 64-bit Office 2013 installed.
You can’t open a Microsoft SharePoint list in Datasheet view. Cause. This behavior is by design. This issue occurs if one or more of the following conditions are true: A version of Microsoft Office that includes the datasheet component isn’t installed on the computer. Note The datasheet component isn’t available in 64-bit versions of Office.
Why does pasting from Excel to list datasheet not work?
The only issue is pasting a multi line row causes content after a line break to drop to another cell (in subsequent rows) OR to throw an error. If you took the trouble to try it for yourself, you would know that. As usual, it’s poorly designed without sufficient consideration for the things users are likely to want to do. Was this reply helpful?
Why does Ps datasheet not work with Excel?
PS Datasheet has nothing to do with Excel Services. Its controlled by a DLL that’s supplied with Microsoft Office. If your running 64-bit Office then normally the datasheet view doesn’t work but if you also have some office 32 bit stuff installed (or commonly people install the Access 2007 Runtime) then it will.
You can find both of them on the list ribbon: Quick Edit will open a spreadsheet view of your list online. Export to Excel requires desktop Excel and will download the data to a local Excel file. Datasheet view doesn’t exist in Sharepoint 2013 and up, or the O365 Sharepoint Online.
Can you edit datasheet view in Quick Edit View?
Verified that content approval wasn’t turned on, point of contact user’s browser updated, quick edit feature enabled, etc. Quick Edit view would allow editing in what we know as datasheet view, and two days ago, the Datasheet view based on the datasheet view option was functional.