Tag Info

New answers tagged

0

None of the above should be necessary. The "Action" options are dependent on the view used. Open the "Overview" view, click "Actions" and the export option magically appears. There's no way anyone would know this so this is a good example of the bad design / UX that plagues Sharepoint.


1

Their no OOTB way to handle these kind of situation. One workaround i am thinking,If both files are identical then upload both files in SharePoint library. After that you can use PowerQuery to Consolidate both files and then create the list on the basis of new file. Consolidate Multiple Excel Files in SharePoint using PowerQuery Another method, create a ...


1

This feature is not available as OOTB. but you can develop custom solutions as below develop office add-on's which can interact with SharePoint and merge from two excel sources in to single list. create two lists and the develop ribbon action with a custom layouts page say "export" in which the list data will be updated to the final target based on list ...


1

Yes, You can do it.But for a two-way synchronization you have to download a free Add-In from Microsoft. With this tool you have to create a list in Excel, publish it to a SharePoint list and synchronize with it. Once you install it, then you should now see under the Design tab a SharePoint section with a button called Publish and allow sync. Please follow ...


2

It is working after disabling Impersonation 1.) Start IIS -> Expand Server -> Expand Sites 2.) Select SharePoint Web Services Site and click on Authentication from right panel. 3.) Disable ASP.NET Impersonation (if enabled)


2

The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled. The solution is to disable the ASP.NET Impersonation again. Go to IIS Manager (Start, Administrative Tools, Internet Information Services (IIS) Manager). Expand the Sites node on the server running the Excel Services Service ...


1

If you have the excel Service enabled then this problem is most probably with ASP.NET Impersonation. Solution: Disable the ASP.NET Impersonation at the Server level and "SharePoint Web Services" level. Via: IIS > Authentication > ASP.NET Impersonation -- Microsoft Knowledgebase entry IF no ECS configured in the farm then check this


3

Is this behavior for all users or only few and what about browser? In the real world scenario it should work, just make sure the Enable Client Integration at web app level. Central Administration > Application Management > Manage Web Applications > select the web application > Click Authentication Providers > select default zone, and select Yes for ...


1

Since Excel Services in SharePoint 2013/Online supports supports OData, the following examples demonstrate how to retrieve table content: https://contoso.sharepoint.com/_vti_bin/ExcelRest.aspx/Documents/ciscoexpo.xlsx/OData/CiscoSalesTable get all table data ...


0

The answer fro AbrahamJP worked for me just fine! Thanks man, was struggling with that issue for 2 days. My laptop turned off due to battery exhaustion, I think this is the reason of creation of those annoying temp files. Clearing OfficeFileCache fixed the issue.


1

If your SharePoint site supports browsing a document library with Windows Explorer, do that first and then run the following snippet from within a code module in Excel. The code loops through the library and captures any file with an XML file type: Dim strFile As String Dim strFileType As String strFile = ...


0

Depending on your requirements there may be no way. You can use Refresh on open or periodic refresh: http://office.microsoft.com/en-001/sharepoint-server-help/refresh-external-data-in-excel-services-HA010105474.aspx Have a look also at these threads: Excel web part from list - Autorefresh ...


0

I think the best solution would be to upload a new file (maybe overwritting the old one) using the rest API. jQuery(document).ready(function () { // Check for FileReader API (HTML5) support. if (!window.FileReader) { alert('This browser does not support the FileReader API.'); } }); // Upload the file. // You can upload files up to 2 GB ...



Top 50 recent answers are included