{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-09-07T02:03:56+00:00","modifiedTime":"2016-09-07T02:03:56+00:00","timestamp":"2022-09-14T18:15:42+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel Services for SharePoint","strippedTitle":"excel services for sharepoint","slug":"excel-services-sharepoint","canonicalUrl":"","seo":{"metaDescription":"The mechanism that allows for the publishing of Excel documents to SharePoint as interactive web pages is Excel Services. Excel Services is a broader term to de","noIndex":0,"noFollow":0},"content":"The mechanism that allows for the publishing of Excel documents to SharePoint as interactive web pages is Excel Services. Excel Services is a broader term to describe these three components:\r\n<ul>\r\n\t<li><strong>Excel Calculation Services:</strong> Serves as the primary engine of Excel services. This component loads Excel documents, runs calculations on the Excel sheet, and runs the refresh process for any embedded data connection.</li>\r\n\t<li><strong>Excel Web Access:</strong> Allows users to interact with Excel through a web browser.</li>\r\n\t<li><strong>Excel Web Services:</strong> Hosted in SharePoint Services, it provides developers with an application programming interface (API) to build custom applications based on the Excel workbook.</li>\r\n</ul>\r\nWhen you publish a workbook to Excel Services, your audience can interact with your Excel file in several ways:\r\n<ul>\r\n\t<li>View workbooks that contain a data model and Power View reports.</li>\r\n\t<li>Navigate between worksheets.</li>\r\n\t<li>Sort and filter data.</li>\r\n\t<li>Work with pivot tables.</li>\r\n\t<li>Use slicers and pivot table report filters.</li>\r\n\t<li>Refresh data for embedded data connections.</li>\r\n</ul>","description":"The mechanism that allows for the publishing of Excel documents to SharePoint as interactive web pages is Excel Services. Excel Services is a broader term to describe these three components:\r\n<ul>\r\n\t<li><strong>Excel Calculation Services:</strong> Serves as the primary engine of Excel services. This component loads Excel documents, runs calculations on the Excel sheet, and runs the refresh process for any embedded data connection.</li>\r\n\t<li><strong>Excel Web Access:</strong> Allows users to interact with Excel through a web browser.</li>\r\n\t<li><strong>Excel Web Services:</strong> Hosted in SharePoint Services, it provides developers with an application programming interface (API) to build custom applications based on the Excel workbook.</li>\r\n</ul>\r\nWhen you publish a workbook to Excel Services, your audience can interact with your Excel file in several ways:\r\n<ul>\r\n\t<li>View workbooks that contain a data model and Power View reports.</li>\r\n\t<li>Navigate between worksheets.</li>\r\n\t<li>Sort and filter data.</li>\r\n\t<li>Work with pivot tables.</li>\r\n\t<li>Use slicers and pivot table report filters.</li>\r\n\t<li>Refresh data for embedded data connections.</li>\r\n</ul>","blurb":"","authors":[{"authorId":8969,"name":"Michael Alexander","slug":"michael-alexander","description":" <p><B>Michael Alexander </b>is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community. </p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8969"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":172026,"title":"Repurposing Items for Beautiful Holiday Decorating","slug":"decorating-for-the-holidays-with-what-you-already-have","categoryList":["home-auto-hobbies","crafts","gifts-holidays"],"_links":{"self":"/articles/172026"}},{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":193770,"title":"How to Play Rummy: All You Need to Know","slug":"rummy-understanding-the-rules-and-starting-a-game","categoryList":["home-auto-hobbies","games","card-games","general-card-games"],"_links":{"self":"/articles/193770"}},{"articleId":153792,"title":"Format Numbers in Thousands and Millions in Excel Reports","slug":"format-numbers-in-thousands-and-millions-in-excel-reports","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"/articles/153792"}},{"articleId":147241,"title":"How to Use the Z-Table","slug":"how-to-use-the-z-table","categoryList":["academics-the-arts","math","statistics"],"_links":{"self":"/articles/147241"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":224399,"title":"Install and Activate an Excel Power Query Add-In","slug":"install-activate-excel-power-query-add","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/224399"}},{"articleId":224393,"title":"Refresh Data Connections in Published Power Pivot Workbooks","slug":"refresh-data-connections-published-power-pivot-workbooks","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/224393"}},{"articleId":224389,"title":"The Power Pivot Gallery","slug":"power-pivot-gallery","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/224389"}},{"articleId":224382,"title":"Publish an Excel Workbook to SharePoint","slug":"publish-excel-workbook-sharepoint","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/224382"}},{"articleId":224376,"title":"What Is SharePoint?","slug":"what-is-sharepoint","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/224376"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281714,"slug":"excel-power-pivot-power-query-for-dummies","isbn":"9781119844488","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844487/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844487/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119844487-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844487/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844487/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-power-pivot-query-fd-2e-9781119844488-203x255.jpg","width":203,"height":255},"title":"Excel Power Pivot & Power Query For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><B><b data-author-id=\"8969\">Michael Alexander</b> </b>is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community. </p>","authors":[{"authorId":8969,"name":"Michael Alexander","slug":"michael-alexander","description":" <p><B>Michael Alexander </b>is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community. </p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8969"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844488"]}]\" id=\"du-slot-63221a4ec849c\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844488"]}]\" id=\"du-slot-63221a4ed6f0a\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":224379},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-11-22T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/excel-services-sharepoint-224379/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"excel-services-sharepoint-224379"},"fullPath":"/article/technology/software/microsoft-products/excel/excel-services-sharepoint-224379/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Excel Services for SharePoint

By: Michael Alexander and

Updated: 09-07-2016

From The Book: Excel Power Pivot & Power Query For Dummies

Excel Power Pivot & Power Query For Dummies

Book image

Explore Book Buy On Amazon

The mechanism that allows for the publishing of Excel documents to SharePoint as interactive web pages is Excel Services. Excel Services is a broader term to describe these three components:

Excel Calculation Services: Serves as the primary engine of Excel services. This component loads Excel documents, runs calculations on the Excel sheet, and runs the refresh process for any embedded data connection.
Excel Web Access: Allows users to interact with Excel through a web browser.
Excel Web Services: Hosted in SharePoint Services, it provides developers with an application programming interface (API) to build custom applications based on the Excel workbook.

When you publish a workbook to Excel Services, your audience can interact with your Excel file in several ways:

View workbooks that contain a data model and Power View reports.
Navigate between worksheets.
Sort and filter data.
Work with pivot tables.
Use slicers and pivot table report filters.
Refresh data for embedded data connections.

About This Article

This article is from the book:

Excel Power Pivot & Power Query For Dummies ,

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category:

Excel ,