Tagged Questions
1
vote
1answer
40 views
Error while opening sharepoint list in datasheetview and exporting to excel
I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error .
Below is a summary of the issue:
After selecting datasheet view :
"Cannot ...
0
votes
1answer
37 views
Error exporting list to excel - permissions for resource throttling ceiling
What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
0
votes
0answers
52 views
SharePoint 2010 List Excel Export Error
I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
2answers
211 views
Fail to export custom SPList to Excel
Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
2
votes
1answer
38 views
Creating lists within lists, or tables within lists, or…?
I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having ...
1
vote
2answers
147 views
Import a single row from Excel spreadsheet
I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row!
Is ...
0
votes
0answers
33 views
Can I export list instances as .wsp package?
We are having an issue where in our 2010 solution the list instances are populated by an excel spreadsheet import using Microsoft.Office.Interop.Excel. Unfortunately this cannot be done in the UAT ...
1
vote
1answer
408 views
SharePoint List Export to Excel All Columns!
As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
2
votes
1answer
119 views
How to import one single row of data from excel to one list item in a SharePoint 2010 list?
I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
0
votes
1answer
74 views
Create Date Field when using Data Connection in Excel
I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel.
The technique I am using is to go to the list and export it from the ribbon ...
1
vote
1answer
196 views
Sharepoint Excel data table and Chart
Need help about sharepoint.
I have a table data collection currently in ms excel document look like the following image.
every last day of the week the information will be updated (append new ...
1
vote
1answer
289 views
Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?
I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List?
Comments I know would ...
1
vote
6answers
6k views
Update Sharepoint list using excel
I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA).
This can be done from Access not a problem however I need it to be Excel ...
1
vote
0answers
106 views
Excel -> SP List with correct column types?
Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...
0
votes
3answers
4k views
Import Excel to SharePoint list -> Auto-synchonize based on Id
Are there tools available for importing an Excel file to a SharePoint list so that the various column types would be supported, and that the importing data would be synchronized based on an a value in ...
1
vote
3answers
8k views
Import Sharepoint List into Excel Using VBA Only
In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes.
How can I import data directly from a Sharepoint ...
3
votes
2answers
3k views
Permission levels for user exporting list into excelsheet sharepoint 2010
What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
2
votes
2answers
1k views
Error - while exporting a Sharepoint List (Export to Excel)
Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues.
Note:
He is ...
0
votes
0answers
471 views
Import Excel as List Fails
I have an Excel Spreadsheet that I want to import into SharePoint 2010 as a list but upon doing so I receive the following errors. As a work around I have saved the spreadsheet as csv and then ...
2
votes
1answer
538 views
Export custom list to excel
I'm using SharePoint 2007. I have created custom-list.
The list contains one column from "Person and group" type, show field: E-mail.
I fill in data in the list column and export this list to excel ...
1
vote
3answers
1k views
Can You Enhance the “Export to Spreadsheet” Action for SharePoint Lists?
Do you know of any resources/solutions to enhance the List’s “Export to Spreadsheet” function so that, once the data is opened in Excel, something would trigger VBA Macro(s) to start formatting the ...
0
votes
0answers
194 views
Import from Excel Spreadsheet works in IE6 not IE8
I'm having an issue in SharePoint 2007 in IE 8 where, when creating a new List using Excel Spreadsheet Import, I get redirected to a 403 error. This feature works in IE 6 but not IE 8. Can anyone ...
1
vote
1answer
1k views
Can I import data from an Excel .iqy file to a sharepoint list?
Can I import an .iqy file into SharePoint 2010 list? Help, please.
3
votes
3answers
10k views
possible ways to import an excel spreadsheet to a sharepoint 2010 list?
I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list.
I've seen on codeplex a free tool for MOSS/wss ...
4
votes
4answers
5k views
How to migrate a 2007 sharepoint list to 2010?
We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.
what's the best and fastest method?
thanks in advance
1
vote
2answers
710 views
How do I make a easy print out (overview like excel) in Sharepoint?
If we use action items for projects/meetings and we want to make an easy print overview, this seems to be impossible. Any ideas or suggestions?
