A type of list view that organizes list columns into a spreadsheet format and can enable editing of multiple items at once without having to open each individual item.

learn more… | top users | synonyms

2
votes
2answers
600 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
0
votes
2answers
188 views

Cut and Paste not working in Datasheet view Sharepoint 2013 O365

I have a question regarding an unusual error that I can't seem to resolve. I have a document library and am trying to cut and paste metadata from an excel 2013 spreadsheet into columns in a datasheet ...
4
votes
1answer
1k views

SharePoint List with multiple content types and the datasheet view

According to this thread. SharePoint 2010 does not "support" using the datasheet view with multiple content types configured anymore. But maybe somebody knows a workaround for my problem: I have a ...
1
vote
1answer
24 views

Sharepoint 2007 Datasheet View

I have read and read and read many sites on this and I have read a bunch from this site. I have a user that can't use datasheet view mode. The user was having an issue with not being able to export to ...
1
vote
1answer
129 views

Is it possible to display the DataView Webpart in datasheet view?

Is it possible to display the DataView Webpart in datasheet view?
1
vote
1answer
78 views

Can I lock the cells size in a datasheet view?

I'm working on Sharepoint2010. I have a datasheet which users can edit free. However I've noticed that everyone can change the size of the cells and even add other columns. How can I prevent any user ...
0
votes
1answer
20 views

One user is unable to open in explorer/view in datasheet

One member of my team has lost the ability to open in explorer view and view in datasheet. Just randomly, and we cannot work out why. All settings are matching of his machine is matching with mine. ...
0
votes
1answer
38 views

Read Only field in View

We migrated a List with a field from 2010 where it was Read Only in Datasheet view. But in 2013 the Enhanced Rich Text field is now Editable. In 2013, Is there a way to make the Enhanced Text Field ...
0
votes
1answer
13 views

Can I create a group of dynamically added recipients, based on a datasheet?

I want my intranet users to send email to a distribution group. Not so strange so far, just a regular send list. But instead of a classic list with individually added recipients, they should be ...
0
votes
1answer
101 views

Datasheet View Cannot Access a Closed Stream

I am running into a problem where I have a Document Library with 2 Choices column. Each has it's own options. The problem is when I use the Datasheet View to edit these columns (or one of them), then ...
0
votes
1answer
36 views

How to get rid of read-only column in datasheet view?

I'm trying to add lots of event to my calendar, so I'm using datasheet view of my calendar. But I found I can't copy-paste whole rows due to the recurrence column is read-only, and I can't hide it in ...
0
votes
1answer
20 views

No columns in datasheet view

I am unable to see any columns in the datasheet view of any list. Here's what I see: My coworker is able to see all columns as expected. Any ideas why this may be the case?
0
votes
1answer
19 views

How to show “edit in access” button

how to add the "Edit in Access" in the Ribbon? Currently, the Ribbon has the following: Export to Spreadsheet, View RRS Feed, Alert Me. thanks
0
votes
1answer
10 views

Combining Formulas

I need to combine the following formulas for SharePoint 2013. I've validated that each works separately, but when I try combining them I keep getting an error message. Any suggestions: ...
0
votes
1answer
50 views

How does Datasheet View Calculate width?

I have created a custom masterpage, and everything works except for the datasheet view. The problem I have is the scrollbar on the datasheet view goes passed the end of the datasheet window. If I ...
0
votes
1answer
291 views

can I use a wildcard in a datasheet view custom filter to NOT show titles that begin with certain words?

I have a calendar list view and want to be able to filter on the title to NOT show items that begin with the word Deleted. Can you use a wildcard at the end of Deleted to grab all titles that begin ...
0
votes
1answer
333 views

List Datasheet view stuck

I have one list where it opens like normal in the Standard View format and as expected I can switch to Datasheet View. The problem occurs when I want to switch back to Standard View. When in ...
0
votes
1answer
542 views

SharePoint 2010 List Data Sheet Error

I have list with about 19.000 items. When I change the view to the DataSheetView, after a few minutes I'm gettin this error: " Cannot connect to the server at this time. You can continue working with ...
4
votes
0answers
304 views

How to maintain line breaks within a 2013 multi-line task field after datasheet edit

We use datasheets to edit multi-line task lists. Since being migrated to SharePoint 2013 the new datasheet view doesn't allow us to maintain line breaks after we stop editing the datasheet. Can ...
3
votes
0answers
185 views

How to make cascade dropdown list in Datasheet View/Quick Edit mode?

I have a list with a need for cascade dropdown list. I've followed the instruction here and successfully create a cascade dropdown in a form. However, I'd like to ask for the possibility of creating ...
2
votes
0answers
238 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
1
vote
0answers
16 views

Configure Hyperlink using calculated field to display in “Datasheet View”

We have a requirement to show hyperlink (URL underlying a text) in Datasheet view. Approach 1: We tried to create a hyperlink field and configured a WF to concatenate the URLs. It is working fine ...
1
vote
0answers
41 views

Data view on lists not working to specific user

On our SharePoint 2010 site, one of the user is having full control but is unable to view datasheet view on any of the lists. When she clicks on datasheet view it is showing empty, and doesn't show ...
1
vote
0answers
29 views

Read Only fields in Datasheet view 2010 are Editable in 2013

We migrated a list from 2010 to 2013. The 2010 Version used an Access Web Datasheet View. 2013 uses the Quick Edit / Datasheet view. The fields that were Multiple Lines of text (Enhanced Rich) have ...
1
vote
0answers
80 views

Feed a sharepoint list from a google sheet

I have a Google sheet that's being fed from a Google form. I am looking to import the new data into a list on Sharepoint as people continue to submit new items through the form. So far, I've been ...
1
vote
0answers
227 views

Disable datasheet/Quick Edit mode in SP 2013 on all views but one

Is there a proper way to do this in SP 2013? In 2010, you could just create your datasheet view and then click "disable editing in datasheet view" to prevent regular views from being converted. An ...
1
vote
0answers
85 views

Applying Datasheet view on a GridView Sharepoint

I was wondering if it is possible to apply Datasheet view onto a grid view found in an application page. The grid View was used such that the data is filtered out such that only data concerning the ...
1
vote
0answers
309 views

Form Library Updating fields in Datasheet view cause error

I have an InfoPath form that has been published and several fields have been promoted so that we can edit the fields in datasheet view. However, there are certain instances when we attempt to enter in ...
1
vote
0answers
86 views

How to find data source for a SharePoint 2007 Access Web Datasheet

I inherited a SharePoint 2007 site. There is a Access Web datasheet that is retrieving data from some kind of data source. The user has informed me that it is no longer updating. For further ...
1
vote
0answers
138 views

Visible Column Descriptions in Datasheet View

Is there a way to change a Datasheet View in SharePoint 2010 so when a user hovers over the name of a column they'll get more descriptive text about the given column? Or something like a comment in a ...
0
votes
0answers
24 views

List DataSheet View: Notate Filtered Columns

When you filter a table in Excel using a column, it shows a filter icon. When working with a SharePoint (Services 3.0) list in Datasheet View and filtering on multiple columns, is there a way to get ...
0
votes
0answers
20 views

Content Type Lookup Field is Read-Only

i cant set the content-type column in the datasheet view in MS access. sharepoint tells me the column is read-only but i cant find it in the column list because its a system standart and only looks ...
0
votes
0answers
26 views

Error in Datasheet view

I'm really blown away by this so I'm hoping someone can tell me I'm crazy. If I create a fresh list with 1 Optional field in it, then I remove the required 'Title' field and try to add an item in ...
0
votes
0answers
17 views

Lookup column displaying 0000000 in datasheet view

List A has a number column which has been looked up in List B. In datasheet view (only), the lookup column in List B displays 0's. For example, the value of List A is just 3, but in List B datasheet ...
0
votes
0answers
24 views

DataSheetView with Read-permission displays no items

When users with only Read-Permission access a DataSheet View in SP2013, the items in the list are not displayed. Do I need to create a new view for readonly users or is there a more elegant way to ...
0
votes
0answers
28 views

Datasheet view content types read only

We have a document library with 5 different content types. After bulk upload some documents an user can't change the content type in datasheet view. He gets the error message "column is read only". ...
0
votes
0answers
24 views

An unexpected error has ocurred. Changes to your data cannot be saved

When attempting to edit a column in a list I have, I instantly get following error message. Certain items update fine, but a very large amount fails instantly with this error. What could be causing ...
0
votes
0answers
22 views

error;#1 Datasheet view

I've been asked to look at an issue in a share point 2010 list, multiple rows in a specific column contains simply following error;#1 rather than the expected data. What does error;#1 mean? I ...
0
votes
0answers
39 views

2010 - List page editing with datasheet view

I have been asked to modify an existing list view using a datasheet web part to include static text to the right of the list (they want this text to constantly appear as users scroll down the ...
0
votes
0answers
60 views

Datasheet view changing size after zooming out and zooming back in

When i switch to datasheet view in a list the s4-widecontentarea will have a horizontal scroll bar. the right end of the datasheet view will be visible only if the horizontal scroll is moved to the ...
0
votes
0answers
177 views

Sharepoint 2013 missing a feature in edit list datasheet mode

I have a client who used the custom filter in 2010 quite heavily. On 2013, it is no longer available. Anyone know a way outside of a view. A view would work but the client needs to change it on the ...
0
votes
0answers
30 views

Populate a column in SharePoint

I have 2 Different SharePoint installations. The new one is missing a column from when I used a tool to migrate. Now if I use the datasheet and export the missing column and its values to excel why ...
0
votes
0answers
583 views

Unable to Show Totals On Datasheet View

I have a SharePoint 2013 installation where a list is being displayed in Data Sheet view. When you select the option for the view to show totals for specific columns, the totals do not display until ...