Tag Info

New answers tagged

0

i finally found a solution. I've created a ribbon with javascript. it creates a view with selected items (making is query) then i use the url to export and after a time, i delete the view. It can be use on any list <script type='text/javascript'> var view; var url = decodeURIComponent(document.URL); var context = SP.ClientContext.get_current(); ...


0

You can't export selected items, even if you use the columns to filter them. You only export a whole view. If you need to update items, you can't do it with office 2010, but you can do it with office 2003. Weird.... You can find more information on the following book: ...


0

If i don't remember it wrong, you can do it by first create an list view (private or public) to filter out only the items that you want, and then use the "export to excel" option in the toolbar. This should get you only the items present in the list view. Or you just could export the whole list to excel and remove the rows that you don't need anymore, or ...


0

I came across similar issue before. It appears to be the schema synchronization issue between SharePoint and Office applications. Office applications save data in XML format internally and for some reason, it cannot recognize the type of data. I could not find a fix for it and ended up deleting and recreating the column. Please make sure you backup the ...


0

I assume that "the list the infopath is based on" means that you are talking about a SharePoint list form that you are customising with InfoPath. In that case, the answer is: No, you cannot create a button in the form that extracts the whole list to Excel. Such functionality would require code that is not available in InfoPath list forms. You can export ...


0

The file was being saved locally by default for some reason. After searching through the setting and tools of IE I found out that the user with the problem was running IE in compatability mode which was cause the file to be saved locally by default. Once the compatability mode was turned off everything was working as it should.


1

There are two ways I can think of. Create a timer job. Schedule a SharePoint TimerJob to run daily or for every n number of hours and populate a list which will contain the excel file content. Design a Business Connectivity Service through Visual Studio and let it read data from the excel file every time it is loaded. This does not have any issue from the ...


1

Here is the answer for Excel. A similar solution should work for Visio. Create a new column in your library called "SPVersion". Use SharePoint Designer to create a workflow that copies the file version ("Current Item" "Version") to your SPVersion column. In Excel, add the following VBA code to the ThisWorkbook module: Private Sub ...



Top 50 recent answers are included