[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SharePoint 2016 Online – Web Part “Excel Web Access” is missing

Posted on 2016-10-06
10
Medium Priority
?
1,005 Views
Last Modified: 2016-10-30
I am a new subscriber to Office 365 Enterprise E3.  As far as I know, I have everything completely installed, at least the 2016 Office components all work in both desktop and online configurations. Working through some tutorials, I notice that under “Web Part”, “Categories”, “Business Data”, I am missing all of the expected items, including “Excel Web Access”.  This picture is from a training video, but IS NOT what I see on my Web Part selections.  How do I turn on this list of Business Data items?  I would also like to have Access available as a Web Part or Web App.
What I expect to see, but don't.
0
Comment
Question by:DAY 3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
  • 2
10 Comments
 
LVL 9

Expert Comment

by:Koen
ID: 41833183
you have to turn on 'Entreprise features' on your site/collection.

go to site settings, select site features, and turn on 'enterprise features'
0
 

Author Comment

by:DAY 3
ID: 41834137
Thank you for responding Koen.  After I posted this question, I found that switch your talking about in the Site Settings called "SharePoint Server Enterprise Site features
Features such as Visio Services, Access Services, and Excel Services Application, included in the SharePoint Server Enterprise License."

Unfortunately, this was already set to Active. So I Deactivated it, reopened the site and then set it to Active again.  No change.
Are their other of these switches which could unlock these features for me?
0
 
LVL 22
ID: 41835890
the menus change so much -- perhaps the option you want is located somewhere else now if the training video was made awhile back
0
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:DAY 3
ID: 41841157
Thanks for your comment Crystal.  I have tried every switch and menu option I can find.  My early exposure to these Office365/SharePoint/Azure/OneDrive Admin options and web settings is very confusing.  It seems that they change so much during the past couple years that even the "experienced" users stumble around to find things.
Over the years, I have grown to count on the Experts here.
This problem is really hanging me up.  Still no solution.
0
 
LVL 9

Expert Comment

by:Koen
ID: 41841379
You have this setting also in the site features...not only in the collection settings
0
 
LVL 22
ID: 41841950
have you created a Site yet?
0
 

Author Comment

by:DAY 3
ID: 41843861
Crystal, I have created a couple test sites to learn in.
0
 

Accepted Solution

by:
DAY 3 earned 0 total points
ID: 41853237
I may have found the solution, but because this setting is turned off by default on all new sites, I'm shocked that my problem and solution isn't more popular and easy to find.

I need to enable the custom script feature in SharePoint admin center-> settings?
the Web Parts in Business Data Web Part Category are invisible when this feature is disabled.

To turn scripting capabilities on or off refer to this article:
https://support.office.com/en-us/article/turn-scripting-capabilities-on-or-off-1f2c515f-5d7e-448a-9fd7-835da935584f

They say that it can take up to 24 hours before this change is available.  So I will report back tomorrow if this was the solution.  But from every indication I can see, it is.
0
 

Author Comment

by:DAY 3
ID: 41859374
The solution I last posted on 2016-10-20 was a simple and complete solution to my problem.
0
 

Author Closing Comment

by:DAY 3
ID: 41865726
The other suggestions were good steps that I had already tried and described in my opening presentation of the question, but was not read or understood.
I wasn't looking for a work-around.
The link I found was a direct and complete solution offered by Microsoft.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question