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

0
votes
1answer
16 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
0answers
23 views

The list cannot be 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 ...
1
vote
1answer
28 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
0answers
42 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
0
votes
2answers
31 views

Datasheet style forms

Is there any way to do a datasheet type view for a form. I'd like to be able to allow people to enter multiple list items at once without giving them access to see the whole list.
1
vote
2answers
54 views

Sharepoint Standard View vs Datasheet View - Records showup

I have a weird problem. I have created 2 views, lets say ViewA and ViewB in a list with the same criteria. View A is a Standard View View B is a Datasheet View Strangely ViewA returns the records ...
0
votes
0answers
35 views

Datasheet View hyper-link and column editing errors

I encountered an issue when using SharePoint 2010 having upgraded from office 2007 to 2013 (resolved here). Having installed the patch I've discovered that the datasheet view no longer allows me to do ...
0
votes
0answers
28 views

make content type column editable in datasheet view

I'm face an issue in a document library for a sharepoint 2010. I'm in datasheet view and i'd like to modify the column content type but it's in read only. Are there a way to do this?
0
votes
1answer
48 views

Disable automatic saving in Datasheet view

In the datasheet view of our list, if someone modifies a cell and then clicks into another one, changes are automatically saved. And you cannot "undo" them. Would there be a solution to deactivate ...
0
votes
0answers
25 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
1answer
101 views

Filter SharePoint 2010 datasheet view based on currentusergroups out of box

Please help if there is a solution out of box in SharePoint 2010, which helps filter datasheet view on currentusergroup. Through sharepoint designer, it is doable to change CAML <Query> ...
0
votes
1answer
62 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
0answers
13 views

Embedding the Survey All responses view within a web part zone

SharePoint 2007 Standard Is it possible to embed just a view (All Responses) from a SharePoint Survey's AllItems.aspx into a web part zone? I'd like to embed this as a ways to allow a user to edit ...
0
votes
1answer
109 views

Change Font Color in Datasheet View

I have a list that I have created in SharePoint 2010. Some of my customers prefer working in “Datasheet View” only. Can they change the font color to red in while in Datasheet View, or do they have ...
0
votes
2answers
61 views

Prevent datasheet mode of a standard view?

I have a standard view which has columns that should not be editable by everyone but need to be visible in the default view. There is a batch update view that is Datasheet, but I need to make sure ...
0
votes
2answers
72 views

Can not toggle back to Standard view of List

I am facing a very unique problem, for which i am not even able to understand, what to look for the internet. To give a brief : I created a list from some List Template with content. Than added a few ...
2
votes
1answer
92 views

How can I tell in a Sharepoint 2010 event receiver if the list item was added in datasheet view or not?

I'm a novice Sharepoint developer, so please forgive what is probably a very simple question. I have an event receiver on a custom list in Sharepoint 2010. I need to be able to display custom error ...
0
votes
1answer
93 views

How to make a list column and its items read only in datasheet view?

Is it possible to make a list items read only in datasheet view? Need the steps on making the datasheet view to be read only for a list. Thanks
1
vote
1answer
89 views

Can the Datasheet view open a URL field in a new window?

I have a list which contains a column containing a URL. When viewing this list using the Datashseet view, I want the URL to open up in a separate or targeted window, so as to not redirect away from ...
1
vote
1answer
350 views

List Datasheet view blank

I have a List with some data in it. I can see the data while in standard view however when I switch to Datasheet view I only see a blank datasheet (no headings or data, just the MS Access icon and the ...
0
votes
2answers
208 views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
1
vote
2answers
101 views

Pasting a rendered link to a rich-text column with the list in datasheet view

I'm trying to paste a rendered link, i.e., a link from within a Word or Excel file, into a rich-text column in SharePoint's datasheet view... Pasting from Excel, I get a working link, but it's the URL ...
0
votes
1answer
80 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 ...
1
vote
0answers
53 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 ...
2
votes
1answer
544 views

Filtering datasheet view in Sharepoint 2010

I want to create a filter on Multiline Text Column inside a Datasheet View by means of out of the box features. Is it possible to provision such a feature so that when I click on the dropdown on such ...
1
vote
0answers
131 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
1answer
106 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
0answers
50 views

datasheet view showing duplicates only one time

Is there a way to show sort/filter a column, e.g. Assigned to to only show one time? For example John Doe John Doe Mark Miller James Bond Now I want to filter the datasheet view to only show: ...
0
votes
1answer
533 views

How can I restrict users from creating views in the Datasheet view in SP 2013?

I need to restrict users (with Contribute rights) ability to create Datasheet view. Also, how may I disable Quick Edit mode in all views?
0
votes
0answers
14 views

One user/group updates via datasheet view,other users/groups single record with approval?

I have created a list on a SharePoint site. I need to configure the list permission so that one single user is allowed to use the datasheet view and can perform updates without approval all other ...
0
votes
2answers
911 views

Data Sheet view issues

I have a list with two views 1.data sheet view 2.standard view. users are able to edit datasheet view and standard view. The issue is when users want to edit Standard view in data sheet they are ...
0
votes
1answer
1k views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
3
votes
1answer
724 views

SharePoint 2013: Adding old Access Datasheet View

We have migrated a lot of sites from SharePoint 2007 to SharePoint 2013. I observed a very unique behaviour, if my SharePoint 2007 list contained a Access Datasheet view, they remain the same and ...
1
vote
0answers
124 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 anyone ...
0
votes
0answers
237 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 ...
2
votes
1answer
73 views

DataSheet View opens, but edits result in non-specific errors

SP 2010 Workstation = Win7 x64, Office 2010 x64, Office 2007 DataConn Components x32, MSIE 9 x32 I am trying to edit the metadata properties of several files in datasheet view. Datasheet view opens ...
0
votes
2answers
92 views

Datasheet view display wrong data

I have standart view filtered by choice field. Standart view shows me 748 items. Then I switch to Datasheet View (by button on ribbon) same view shows me 175 items. Also datasheets view shows some ...
0
votes
1answer
183 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 ...
1
vote
0answers
66 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 ...
2
votes
0answers
145 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
2answers
2k views

Error on adding people in SP 2013 datasheet view

When editing a Person or Group field in a datasheet view I always get the following error: The user does not exist or is not unique. If I enter the same name in the edit form it works fine. ...
1
vote
0answers
85 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
1answer
156 views

Custom alternative to Datasheet view of SharePoint

I have taxonomy fields as well as rich text boxes in my SharePoint 2010 list which needs to be edited in datasheet view so that bulk update is possible. Also I have Workflow goin on that list so ...
1
vote
1answer
2k views

Summary Links Web part

Got about 60 links to add to a custom sharepoint, and I am going to use a summary link web part with an 'accordion style' like Stefan Bauer created. Adding a few are not a problem - but this is 60 ...
2
votes
2answers
957 views

Unable open to List in Data Sheet List View

I am unable open my list in data sheet list view mode in Chrome browser but I am able to open in IE. Does any one know what kind of settings I need to change.
1
vote
1answer
81 views

How do I prevent “comments” cell within datasheet view from populating black after exiting cell?

A user of our SharePoint 2007 Server hosted database has been running into the issue shown within the title of this post. She is working remotely so, it is difficult for me to figure out what ...
0
votes
1answer
2k views

Datasheet View and Slow Query StackTrace-Managed

I have a list with 20000 items when I'm trying to open it in Datasheet View it shows me 100 records and then alert on the screen. Cannot connect to the server at this time. You can continue ...
4
votes
1answer
929 views

External List in Datasheet View

How to I get an External List in Datasheet View? I have a List, whereby I have Looked up a Column from an External List. The column appears as readonly in Datasheet View, but behaves normally using ...
0
votes
1answer
717 views

SP 2007 - Disable adding/deleting rows in a list's datasheet view but keep editing intact

We often get requests to remove the users' ability to add/remove items from our sharepoint lists, while still allowing them to edit existing items. We've traditionally accomplished this by adding some ...
0
votes
1answer
161 views

Why does a freeform metadata field behave differently in Sheet View vs. Metadata Dialog Boxes?

I've recently begun migrating some documents that require a freeform "description" metadata field. I have this field defined as multi-line text with When I bring in a new document to my library and ...