Tag Info

New answers tagged

0

I got the answer from here. Turns out I can just immediately paste the direct URL of the .odc file from the Data Connection Library in the Select Data Source window. The tricky part was finding where to paste the url, so I highlighted where to paste it in case someone encounters said issue.


0

Append Web=1 to the url to instruct it where to open. Of course you have to have all the prereqs in place. /PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=1 Opens it in Excel Services web page /PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=0 Opens it in excel


0

Actually you can't refresh the data by this way. Export to excel option was not supported by excel service. You need use the odata from sharepoint list. http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/07/11/excel-services-using-a-sharepoint-list-as-a-data-source.aspx


0

Check the settings in the document library your Excel file is hosted in. In Settings -> Advanced Settings, you have should have "Open in the browser" as your default open behavior. EDIT: If the above doesn't work, change the link's behavior (Page --> Edit --> Link) to "Open in new tab." This should force the document to open in Excel Online.


0

After working with Microsoft support for two months, I finally was able to convince them that it was a bug. Typically I've had good luck with Microsoft Support - that was not the case for this incident. Below is the finding of the test we performed and confirmed at our end. The issue occurs if we have the below configured scenario in the ...


1

Preferred way of reading excel files is with OpenXML SDK. http://msdn.microsoft.com/en-us/library/office/bb448854%28v=office.15%29.aspx


0

In general: when using SAML-based authentication, the identity of the user cannot be delegated to backend systems, like SQL Server. See here: http://sergeluca.wordpress.com/2014/08/08/microsoft-bi-on-premise-forget-saml-authentication/


0

The Enterprise version of SharePoint 2010 has a Chart Web Part under the Business Data category, and is a very simple OOTB solution for this. It can connect to any list on your site and, while it won't automatically refresh if you're viewing it when someone else modifies an item in the connected list, it does generate the chart in realtime whenever you load ...


2

After you click on Export to Excel. Click on Open instead of save. The list would open in Excel. Then just do a Save As from excel File menu.


0

No, web part deployed to SharePoint has to be compiled in 64-bit. http://stackoverflow.com/questions/20710798/microsoft-sharepoint-is-not-supported-in-32-bit-process-please-verify-that-you


0

You can use following JavaScript for achieving this var stsOpen = new ActiveXObject("SharePoint.OpenDocuments.3"); stsOpen.ViewDocument3(window,"http://site/Library/Filename.xlsx",0,''); If your site is non-publishing then you can place JavaScript in the Quick Launch. Check this blog ...


1

Looks Like you installed the SharePoint 2013 Standard versions, All the services apps you trying to create are part of Enterprise License. Check this link for standard vs Enterprise Comparison Now you should update your farm with Enterprise license key, You can change it from central admin > Upgrade and Migration > Convert License Type> enter the ...


0

If you are uncomfortable using Macros, you can try the below. I used =clean(A1) in excel to create a friendly chunk of text to copy and paste into SharePoint. That way the text gets cleaned from Excel first, before pasting into SharePoint. I used Excel 2013 and SharePoint 2013.


1

You need SharePoint Designer. If you have not used it before, it may be a bit daunting. Here are the general steps: Open the site with SharePoint Designer, then open the list. In the Settings page, find the panel for the Workflows and add a new workflow. Edit the workflow and add an action that sets a field's value. You may need a few steps to extract the ...



Top 50 recent answers are included