The datasheet tag has no wiki summary.
0
votes
1answer
6 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
12 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
12 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 ...
0
votes
0answers
13 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 ...
0
votes
0answers
12 views
not all columns appearing in edit in datasheet
I have a customized work order view with the following fields:
ID#, Title, Assigned To, Client, Status, Priority, Due Date, +8 other fields
When I got to Edit in Datasheet, the Client field doesn't ...
1
vote
1answer
63 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.
...
0
votes
0answers
53 views
QuickEdit Error - Can't create new Items
I hope I can get some advice's cause of a problem i discovered earlier in my SharePoint 2013.
There is a strange behavior in my new created lists. If I use QuickEdit to create new items SharePoint ...
1
vote
0answers
31 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
85 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 ...
0
votes
1answer
227 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 ...
0
votes
0answers
60 views
Some infopath fields are populating drop down list options in while editing in sharepoint library datasheet view while others aren't
I have several drop down lists in a pretty simple Infopath form that I'd like to be able to edit in the datasheet view of their library on Sharepoint. After I publish the template form to the library, ...
0
votes
0answers
20 views
“Owned by” field does not display in datasheet view, or when exporting to Excel
I'm what I'd call a 'reasonably savvy' business user, administering a pretty standard SharePoint 2010 project site (actually a sub-site). We are using the built-in Issues and Action Items lists. Both ...
0
votes
0answers
71 views
data sheet view with multiple content types problem
I have got a list with multiple content types. On of the types is inheriting from Folder and is NOT set as default content type. When I try to add list item using data sheet view the inserted item ...
1
vote
2answers
170 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
48 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
0answers
107 views
Filter values of dropdown in DataSheet View
I have a dropdown box that is in a list being updated via datasheet view. Is there any way to filter these dropdown items (JavaScript, OutOfTheBox, etc)? Or a simpler solution, change the default ...
0
votes
1answer
773 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 ...
2
votes
1answer
444 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
279 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
94 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 ...
4
votes
3answers
7k views
Why are fields in Datasheet View read only?
I have four metadata columns into which I cannot paste data for a bulk upload. A diaglog box: "The selected cells are read only" appears when I try to paste.
The cells are defined as "multiple lines ...
0
votes
1answer
845 views
Is it possible to have a Datasheet view as a Webpart?
I am looking for a solution to the above. If it is not possible... is there an alternative to the same?
0
votes
2answers
599 views
Datasheetview copy managedmetadata field
We have a list with 2 metadatafields, however in this list the user wants to use datasheetview to copy many rows, the problem is when you try top copy it says managed metadatafields are readonly, is ...
1
vote
3answers
4k views
Editing in Datasheet View
I opened my list in datasheet view. But I wasn't able to edit in that view - things were read only. How do I enable edition in datasheet view?
1
vote
1answer
387 views
Group By on a DataSheetView
I have a DataSheet view on my library of infopath forms. the forms are basically weekly status reports and what i want to do is total the hours from each report for the month and show a totals row. I ...
0
votes
1answer
325 views
DispForm with child data view
I have two related lists. I have a parent list and a child list, the child list has a column that stores the ID of the parent list. In the parent's EditForm I added a dataview of the child list, and ...
1
vote
1answer
882 views
Text in Datasheet view defaults to black highlighting (can datasheet view be configured at all?)
I'm not overly experienced with Sharepoint, but usually my Google-fu is pretty good...until now. Office 2007, SP 2007, Win7/Vista environment, I am a subsite administrator. When viewing a ...
3
votes
4answers
972 views
How to get Datasheet view working on Macintosh system?
How to get Datasheet view working on Macintosh system. Even many other features are not working on Safari browser. So is there any way to get it working?
2
votes
2answers
248 views
How to make datasheet view 100% of browser height
Does anyone know the best way to remove scolling or even just expand the height of the datasheet view. I have two Sharepoint WSS 3.0 site collections, one displays the default datasheet view at 100% ...
1
vote
2answers
488 views
Datasheet view for sql table?
I would like to manipulate an sql table via web interface in sharepoint the same way I use datasheet view for SharePoint lists.
I would be interested in any kind of a non-commercial solution.
Or would ...
1
vote
1answer
419 views
Most “full control” users can't access datasheet view or export to Excel
All but the administrator users with "full control" and/or "contribute" permissons on a certain list do not recieve the datasheet view option, and when they try to export to Excel there is a ...
1
vote
1answer
972 views
Unable to open task pane or fill down in datasheet view using IE 8
I've received a couple questions from people who all have issues using datasheet view when using IE 8 in SharePoint 2007. I've reproduced this in MOSS and WSS 3.0 with the same result. I use Office ...
0
votes
0answers
294 views
Sharepoint 2007 Access Web Datasheet Missing Data [closed]
I maintain a lot of data for a company using Sharepoint lists. I've noticed istances where I'll put data into the list using the Access Web Datasheet view, and then when I come back to update the data ...
8
votes
1answer
2k views
Understanding Data Sheet view list better in SharePoint 2010
I would like to know more about the features of Data sheet type lists.
Can I use conditional modification to the data sheet rows, for
example changing the color if a column value equal 'X' ?
Can I ...
0
votes
2answers
300 views
calculated fields
I'm using SharePoint 2007 and I'm working on a List in a DataSheet view.
I created the field "Color" - a dropdown field that contains: "Yellow","Green","Blue".
I also created the fields:
...
1
vote
1answer
474 views
Theming a Datasheet View
In my custom theme the background of my theme is a dark grey. When I go onto a datasheet view of a list the dark grey is used as the background colour. Is it possible to target only the datasheet view ...
2
votes
2answers
924 views
Cannot change value in a choice column for some documents
In a hosted WSS 3.0 environment I have a standard document library with some extra columns. For some reason I cannot change the value in a choice column (called: "Status"). The value always is reset ...
0
votes
1answer
423 views
data sheet list view permission
I have created custom list on sharePoint 2007,
on that list I create data-sheet view.
I send a link to the "data-sheet list view" to some users,
in order that those user fill-in data.
I need to ...
1
vote
1answer
533 views
Datasheet View works for a particular permission level only
Datasheet View works for particular permission level only on my site i.e. Contribute Permissions Level only. How can I make it work for all permission levels?
PS: I have installed SP1 upgrade.
1
vote
0answers
807 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 ...
0
votes
1answer
404 views
Should workflows run when creating a new item using the data sheet view?
I have workflow configured to start when an item is created.
Using the datasheet view, when adding a row, the workflows are not fired.
Is this by design?
1
vote
1answer
229 views
Issue with mouse scrolling on a datasheet view when using ie9 and SP2007?
I had a user today who had some issues with the datasheet view, her browser was updated by IT to IE9 and then I was asked to look at the dataview issues which were down to permission level.
All ...
3
votes
1answer
301 views
Can I use JavaScript in 'Edit in DataSheet' mode?
I would like to use some JavaScript in 'Edit in DataSheet' mode to check a value and prompt a user to enter some text.
Is this possible?
3
votes
2answers
2k views
Customising Data Sheet View
I'm using SharePoint 2007, with custom list.
I'm using Content Editor web part in order to design my list.
{In my list the row color determined through the item ststus.
e.g: If the status equal to ...
2
votes
2answers
479 views
How do I create custom control or action that works in a list's DataSheet view?
I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view.
In datasheet view it is showing all the possible ...
2
votes
2answers
2k views
Unable to save changes in Datasheet View
We have a custom list that we are trying to edit in Datasheet view and are getting the following error when the next row is clicked:
Another user has changed the structure of this list. All your
...
1
vote
2answers
1k views
creating datasheet view - but standard view is displayed by default
SPView AllItems = spList.Views["myview"] ;
AllItems.Formats = "<Format Name=\"Modified\"><FormatDef Type=\"ColWidth\" Value=\"534\" /></Format>";
AllItems.Update();
Why isn't ...
1
vote
1answer
166 views
Memory Error on Lists in Spreadsheet View
I have a list in SharePoint 2007 with about 187 items and in the Data View, several of our users are experiencing this error:
The Instruction at "0x3271fe85" referenced memory at "0x00000000". ...
1
vote
1answer
1k views
Solutions for Error: “The Datasheet view is attempting to retrieve data from a different domain”?
A couple users of our SP2007 site have received this error while accessing datasheet views. They are able to view/edit lists in 'standard view' without any issues and their PCs are configured with XP ...
0
votes
1answer
48 views
How do I load files in different subdirectories in a library into Datasheet View?
I know how to load a list of files in a subdirectory into a Datasheet View, but how do I load files in different subdirectories in the same library into the same Datasheet View?
