Tag Info

Hot answers tagged

7

You cannot import an iqy file. It just defines the query for Excel. The only way would be to import the data in excel using the web query and then import (the imported) data from the sheet into the list. Another approach would be to use Excel Services but I think you need to enable the external datasources then (not sure).


6

According to @ToniFrankola http://serverfault.com/questions/73677/disable-export-to-spreadsheet-in-sharepoint-custom-list you need to have permission: [x] Use Client Integration Features In OOTB premission levels this permission is not set only for Restricted Read level. So correct answer to your question is: Minimum OOTB permission level for users to ...


5

I noticed that SharePoint Worksapce was running in the system tray which had the "Shared Documents" library synced, because of this there were some temp files out there in the following location "c:\Users\login_user_name\AppData\Local\Microsoft\Office\14.0\OfficeFileCache" after terminating the Sharepoint workspace and clearing those temp files, I was ...


5

You can synchronize Excel 2007/2010 and SharePoint 2007/2010 with a download and install of a Microsoft Excel Addin. Here are some articles that has detailed description on how this is done - Excel to SharePoint and SharePoint to Excel


5

In SharePoint 2010, sites can export custom list items to Excel using the Export to Excel option in the ribbon toolbar. It will export all items in that particular view in which the option is invoked. SharePoint literally is not exporting the items it creates in the query file instead, which will have the view id and helps to query the SharePoint list data ...


4

If you read this article by Thao Nguyen at Bamboo Solutions you will find 4 different methods for migrating a list from SharePoint 2007 to SharePoint 2010. My preferred method is number 1: Method 1 - Migrate a single list from SharePoint 2007 to 2010 using a list template Save the list as a list template (".stp" file). Download the list template Change ...


4

This is a good question. The ability to retrieve an Excel graph as an image with such a simple REST call is in my opinion the best feature of Excel Services that allows you to achieve an impressive result with a tiny amount of effort. The chart image is generated by Excel Services itself (rather than the Excel Web App). The Excel web application is acting ...


4

I needed to do this for one of my projects. Here are the steps I took. Generate an export for the data you want to share via the out of the box process (ie via the Action Menu). When prompted, name and save this file locally. This is the Excel Query File and it has information about the site, list and view that generates this data. Place the file in the ...


4

The only option is to Upload the file, list and document libraries are different in form and function. You can use the single file uploader, the multiple file uploader, or the Open with Windows Explorer function in the Actions menu. You can create a document content type and attach an Excel templte to it so that new Excel files created in the document ...


4

Open the SharePoint 2010 Central Administration, Go to Application Management => Manage Web Applications and then select your web application. In the Ribbon, select the General Settings => Resource Throttling, There you can see the threshold limit 5000, edit the value as you need and save it.


4

Which Internet Explorer do you use? Be sure to use the 32-bit version instead of the 64-bit. That solved the problem for my user.


3

Have you checked this documentation: Configure the default open behavior for browser-enabled documents (Office Web Apps) You can either disable the Excel Services Application for all site collection in the central administration (Service Applications under APplication Managemend) , or you can disable the Web Access via Feature/Powershell explained in the ...


3

found it. the best way is to export the list to a spreadsheet in 2007 and then import that xslx file in 2010. I found this article very useful: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?List=56f96349-3bb6-4087-94f4-7f95ff4ca81f&ID=91 by the way, I faced a problem when exporting to excel if the site is using forms based authentication with ...


3

There is the option of using datasheet view to copy-paste data, especially if need lookups to other lists or have "choices" already set up. This does require you to normalize the data in your spreadsheet. The downside is that you can't paste in data for columns that are "multi-line" type in datasheet view. Using the above two walk-throughs, you can first ...


3

You can create a new list based on an Excel document. Here are some walk-thrus: http://www.bloggix.com/archive/2010/06/15/import-and-export-data-between-excel-2010-and-sharepoint-2010/ http://sharepointbuzzer.wordpress.com/2010/10/22/import-excel-sheet-as-sharepoint-list/


3

We had to open a case with Microsoft about this same issue. We literally tried every solution suggested in this thread and many others (IE settings, Office Trust Center settings, removing cache directories, etc, etc). It turned out that a pre-release version of Office was installed on the affected machines. The pre-release version (found in Control Panel -> ...


3

I had a similar problem where the export option was not visible in the action menu. As workaround, I found that if I accessed the survey from Site Settings ==> View All Site Content ==> My Survey then the export button is available.


3

Check the advanced settings in the document library. There you have the option to open files in the browser or in the client. You most probably have Browser selected, go for Client here (or Server Default if the default is client). Another setting which you might want to look at is under General Settings of the Web Application: You can choose to have ...


3

Depends how far down the rabbit hole you want to go... I'd recommend forgetting about Excel and simply making a new custom list in SharePoint. Create columns in that list the correspond to what was in your Excel sheet. Once that is done, create a Datasheet view. You'll end up with a web page that has something that looks like a spreadsheet on it (it's ...


3

I found a way to do it finally via "The Internet". Here is what worked for me. Sub ImportSharePointList() Dim objMyList As ListObject Dim objWksheet As Worksheet Dim strSPServer As String Const SERVER As String = "mysite:8003/sites/the-sharepoint-thing/" Const LISTNAME As String = "{D1F1C2ED-81BA-41CC-A698-XXXXXXXXXXXX}" Const ...


3

Nothing specific to Excel web parts. There is a default maximum number of web parts per page configured in your Web.config. The setting is "WebPartLimits" if you need to modify it. For example: <WebPartLimits MaxZoneParts="50" PropertySize="1048576" /> With that said, however, if you run too many Excel web parts on a single page, it will load ...


3

Doing any local disk access from within SharePoint in a load balanced environment is risky at best. For example, which C: drive is it looking at, the one on Server 1 or the one on Server 2? Where is it writing the updates? Can it be updated on Server 1 but then loaded again from server2, etc., etc.. The first place to start would be to take a look at the ...


3

In a word, no. SharePoint Server can host Excel workbooks in SharePoint pages using Excel Services, but these do not support Macros (for various reasons, the main one is to prevent malicious code from being executed).


3

I suppose you can do it using SharePoint Online preview, please check this article - http://blogs.office.com/b/microsoft-access/archive/2012/07/30/get-started-with-access-2013.aspx


2

Actually I'm pretty sure that this is not supported according to http://office.microsoft.com/en-us/sharepointserver/HA101054571033.aspx specifically under the 'Unsupported Features' section that lists 'External references to linked workbooks'.


2

I have had this same issue. For me it was caused by authentication not working correctly between the browser and office. When you get the hang, see if you can minimise the window, then redisplay it. Usually there is a authentication box hiding somewhere. First, im going to assume this is an intranet? Close all your browsers, when you go to the sharepoint ...


2

Associate your workflow with a content type. Extend Mike's suggestion by creating a new list instance which will already have the content type associated with it. As your workflow is associated to the content type you will have the workflow available in the list.


2

I'm assuming you're looking for a reusable method that's got some automation. I'd imagine you could use an Excel macro to call the lists web service, prompt the user to select a template, create that list, then push the data into the list. You may need to store the list structure CAML in the macro vs. in a template file, as I'm not positive if lists ...


2

Importing spreadsheet is an inbuilt option in SharePoint 2010. You can follow these steps mentioned over here in this video demo -http://www.sharepoint-videos.com/sp10import-spreadsheet-to-create-a-new-list/



Only top voted, non community-wiki answers of a minimum length are eligible