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).


7

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 ...


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 ...


6

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

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 ...


5

Or you can use Sharepoint list synchronizer that will do that for you in a single click: SharePoint List Synchronizer I think there is a free version that you can try out.


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

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

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 -> ...


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

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 ...


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

Here is a trick I've tried in your situation: Change your view in SharePoint to only display like Maximum 1000 rows. (use the Limit in the bottom of the view definition screen) Attempt again to export to Excel - this should work without issues (if it doesn't the problem lies elsewhere in your SharePoint and then you should have a look in ULS) Change back ...


4

There can be many approaches for this particular job (I bank on your statement that you can do this with C#) - Write a custom workflow, when a document is uploaded to a particular document library the workflow triggers Write a custom web part with upload control, when user upload the document you can do all the calculation and accomplish the job Write an ...


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

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

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

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

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

Please check last section of below page: http://flylib.com/books/en/3.464.1.67/1/ To import list from SharePoint: Sub ImportListFromSP() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets(2) Dim src(1) As Variant src(0) = "http://SharePointSiteAddress/_vti_bin" src(1) = "89F90972-FD90-4B04-BCEB-81840A82DA5E" ws.ListObjects.Add ...


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

Add the following to DOCICON.XML (default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML) <Mapping Key="csv" Value="icxltx.png" OpenControl=""/> Then in IIS Manager select the server and then select MIME Types, update the entry for csv to 'application/vnd.ms-excel'. This will allow you to click the ...


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



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