Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel-web-access-webpart]

The Excel Access Web Part displays a Microsoft Office Excel workbook so that you can easily and securely share reports with other users, and analyze and explore data.

0
votes
3answers
497 views

Be careful. This workbook contains one or more queries that might be unsafe

I try to display data using Excel services in a web part. First of all, my Sharepoint version is Sharepoint 2013; In addition, all authentication processes are working properly and I can retrieve the ...
1
vote
2answers
492 views

2010: How to display excel web access web-part page in an iframe?

Is there any way to display page which contains excel web access web-part in an iframe window? I'm getting security error.
3
votes
1answer
913 views

Excel Web Access Web Part won't load any workbook

I've been attempting to troubleshoot an issue on my SharePoint 2016 site with the Excel Web Access. I'm trying to embed a simple work sheet into a page. I should simply be able to open the Web Part ...
2
votes
1answer
54 views

Sharepoint Question/Advice - change excel form/graphs into something more interactive

We currently have an excel file that is a large table that the user fills out and then some graphs are manually created from the data. We have a sharepoint online modern site (using Spfx for any ...
2
votes
1answer
170 views

Document plug-in won't wrap text in Excel cells on the SharePoint page

I am displaying an Excel document on the SharePoint page and for some reason, the cell text is not wrapped and that causes the text to go over each other which looks really bad and unreadable. But ...
1
vote
1answer
12 views

Sharepoint Online Excel Web Access does not works in IE with Publishing enabled

It Appears that SharePoint Online Excel Web Access does not works in IE with Publishing enabled. The fields are blank whereas the same works fine in Edge/Chrome. Could someone please confirm that ...
1
vote
1answer
1k views

Excel Web Access webpart shows error in SharePoint 2016

I am migrating SharePoint 2013 web application to SharePoint 2016 using content database backup/restore approach. I am seeing below error message for all "Excel Web Access" webpart instances in ...
1
vote
1answer
3k views

Excel Services we ran into a problem

I'm running into an issue with Excel Services Web Part. When i add a web part Excel Web Access and try to add a spreadsheet it errors out saying "We're sorry. We ran into a problem completing your ...
1
vote
1answer
144 views

Can I access office.js from SharePoint 2013 content-editor web-part like I can Ewa?

I have HTML and JavaScript that run just fine in a SharePoint 2013 content-editor web-part, from which I can access the Ewa.EwaControl object (https://msdn.microsoft.com/en-us/library/office/ee589018....
0
votes
1answer
29 views

How can I enable a function which prints all the items in an Excel Web Part?

I want to be able to print all the charts from the drop down list. As it is now, I am only available to choose one chart/named item, print it, change item, print and so on. Can someone help me?
0
votes
1answer
73 views

SharePoint Online - Excel Web Access

My worksheet contains button (form control/ActiveX) but SharePoint Online/Excel Web Access does not display it. The button just mainly print another worksheet (printer-friendly version). Is there ...
0
votes
1answer
380 views

Excel Web Access Web Part in SharePoint Online not working

I have added 3 Excel Web Access Web Part on page in SharePoint online. I have display web part on tab click. I have used jquery show , hide . Its working fine in chrome browser. Please see the ...
0
votes
1answer
109 views

Sending a blank value from html form webpart to excel web access webpart

On a SharePoint 2010 page, I have HTML form web part that has a simple text box control and Excel Web Access webpart that shows an excel that too has a name(defined name) and defined as parameters ...
0
votes
1answer
56 views

Excel Alert Prompt

Hey Guys! I was wondering if I can set an alert in an excel document that publishes weekly for a certain individual in SharePoint? Showing what was updated, by who and etc...or no. Thanks!
0
votes
1answer
785 views

How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part

The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
0
votes
1answer
152 views

How to add the Excel file in the page on the Sharepoint 2010 foundation?

I would like to insert an excel file into the Sharepoint page on SP 2010 foundation. I saw we can export list to excel, so that I think maybe we can display the excel file in the page. In SP 2010 ...
0
votes
1answer
200 views

Suddenly error on Excel Web Access web part

I had some real nice Excel Web Access web parts going. Without any clear cause I suddenly get an error message, stating the file cannot be openened due to worksheet protection. It supposedly prevents ...
3
votes
0answers
102 views

Excel webpart showing “Loading” but not showing the excel file

I am using an excel file which uses a dataconnection stored in dataconnection library. The dataconnection gets the data from sql server using Secure store and excel services. I am trying to use the ...
2
votes
0answers
127 views

Request Header issue on SharePoint site

I've made a team site using several Excel Web Access web parts, and a little custom CSS. However, after opening two sub sites, and going for the third, the Excel Web Access web part isn't rendering, ...
1
vote
0answers
22 views

Excel Web Part - remove options from drop down list?

I have a site that contains an Excel web part. The web part has a drop down list for named ranges on the Excel file. The DDL has many names/options that don't appear in my named ranges. Is there ...
1
vote
0answers
16 views

Choice of SP version for solution with Excel Web Services and MDS

I must start to provision a dev environment to create a solution on SharePoint OnPrem. I try to define first what version I could use. Then What service I should use in my SharePoint farm, but I would ...
1
vote
0answers
23 views

Linking web parts of documents that are linked to other documents

I currently have a whiteboard where I have put up documents and charts as a visual representation. I would like to digitalize this board in SharePoint, so that I can make changes in the original ...
1
vote
0answers
169 views

How to maintain scroll position when navigating back from a document

I have an Access Web Datasheet being used to display data from a Sharepoint 2010 Document Library. We access the document to view but when we navigate back to the Access Web Datasheet view the page ...
1
vote
0answers
3k views

We couldn’t load the Data Model. This may be because the Data Model in this workbook is damaged

Requirement Criteria I have SharePoint 2013 on premise. I have an excel sheet which loads data from the SharePoint list using listdata.svc service. I am able to load the data into the excel sheet ...
1
vote
0answers
442 views

Power Query Data Refersh

I used power query in the MS Excel to import data from SharePoint online List, and create a dashboard by using the data of that list. Everything work perfectly when I used that excel on my desktop, ...
1
vote
0answers
97 views

Excel Services In External Website

I'd like to render an excel workbook (specifically a pivot table) using Excel Services on our department's internal website and I am not sure how to do it (and I guess I am not searching correctly on ...
0
votes
0answers
10 views

SharePoint Server 2019 Health Error: [MissingWebPart] class [Microsoft.Office.Excel.WebUI.ExcelWebRenderer]

This SP 2019 farm is connected with OOS and I can view online Excel files stored in SharePoint, but I get the Health Error: [MissingWebPart] WebPart class [e6002ce8-69ee-168a-8f7c-a1d98d51da29] (...