SharePoint Excel Services resources

 

 

Re-enable the PremiumSite Feature after removing PowerPivotGP0|#be9f6e37-d079-4e4e-84f3-416739395df1;L0|#0be9f6e37-d079-4e4e-84f3-416739395df1|PowerPivot;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​After you uninstall the PowerPivot for SharePoint component, Excel Services and other services in the PremiumSite feature are disabled. To re-enable the features for all the SharePoint sites in a SharePoint farm, run the following script
Can't edit workbooks in the browser that have external data connectionsGP0|#b20346d4-3cda-4fd2-9603-5571a7e5e2db;L0|#0b20346d4-3cda-4fd2-9603-5571a7e5e2db|Upgrade;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GP0|#55fb27c6-9a9a-4c40-be08-4801ff88eeec;L0|#055fb27c6-9a9a-4c40-be08-4801ff88eeec|Excel Web Access;GPP|#7c66663a-64ea-4c65-9772-9b3a76b4aa65;GPP|#1bc09cbd-f411-45d5-ad40-bb6b715fb72f;GPP|#a5205c2f-ad79-446f-8d9e-afd0eeecf427 ​Workbooks with external data connections that use Windows authentication cannot be refreshed in the browser. Instead, you are prompted to open the workbook in the Excel client program. Workbooks that have database or Windows credentials stored either in the Secure Store Service or in the connection string can still be edited in the browser. This change applies only when Excel Web App in Office Web Apps Server is used to view workbooks, not when Excel Services in SharePoint Server 2013 is used. Note You can still refresh these workbooks in the Excel client program. Additionally, a service application administrator can configure that workbooks are viewed in SharePoint 2013 instead of Office Web Apps Server.
Using a SharePoint List as a dataGP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​A trick using PowerPivot to allow SharePoint lists to be used as a datasource for a spreedsheet published in a library and displayed in a web part
Excel Services error "The workbook cannot be opened"GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213