Contents
Go to list settings or View combo box and click on “Create View”. Select ‘Datasheet View’, choose it’s name and check columns that you want to see. If you want it by default when someone open the list, check “Make this the default view” option and save the view.
How do I create a Datasheet view in SharePoint 2010?
How to Create a DataSheet View on a List in SharePoint 2010
- Click the List Tab. This will change the ribbon to be contextual to interacting with the actual list as a container, which is where you create the views.
- Click Create View.
- Choose Datasheet View.
- Name the View and Configure Columns.
- Use the View.
What is a Datasheet view in SharePoint?
A Datasheet view displays app data in a web-based spreadsheet in SharePoint. With Datasheet views, you can. Support most column types including Text, Choice, Date, Number, and Lookup columns. Datasheet views don’t display with Multiple Lines of Text columns.
What is Datasheet view used for?
A datasheet is a useful way of viewing data in Access. Most importantly, datasheet view allows a user to view many table records at the same time. In datasheet view, information is displayed in rows and columns—similar to a spreadsheet. Records are displayed as rows, so each row is an individual record.
What is a datasheet view in SharePoint?
What is datasheet view used for?
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.
Can you view SharePoint list in datasheet view?
Note The datasheet component isn’t available in 64-bit versions of Office. The Web browser doesn’t support ActiveX controls. Support for ActiveX controls is disabled. To work around the issue, use one of the following methods: Use another type of SharePoint view, for example, the Quick Edit view that was introduced in SharePoint 2013.
How to create a list in SharePoint datasheet?
To create a new list item in datasheet view, just type values in the last row (the one marked with an asterisk) in the datasheet. The list item is created with the values you typed in. To finish adding the list item, press Enter or click another row in datasheet view. The datasheet creates the list item (see Figure 4 ).
It seems you have created a view with datasheet which tends to open in the edit mode. You can set it to default Standard view. Refer this link to change the default view of the list All the best! Someone probably created a custom View and set it as the default. Browse through the existing Views and find the original View.