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.
57
questions
1
vote
2
answers
88
views
Embedded web parts in sharepoint
So I made a link to a document from one subsite to another subsite in sharepoint.
I have used the embed web part and have inserted the link to the document instead of the iframe code. The document is ...
- 23
1
vote
1
answer
95
views
What are the available options we have to migrate a Web Access database from sharepoint 2010 to sharepoint online
I am working on an existing sharepoint on-premises 2010, and our aim is to migrate this on-premises 2010 to sharepoint online. now i checked the sites and they contain regular document libraries and ...
- 93
0
votes
1
answer
830
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] (...
- 285
1
vote
1
answer
60
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 ...
- 11
0
votes
1
answer
231
views
sharepoint O365 excel web Access is Blank!
I went through lists of similar answered questions but non seemed to have the answer.
We are currently in O365 SharePoint and this is Excel Web Access.
For me and some other employees, this is ...
- 75
0
votes
2
answers
1k
views
Display Excel chart on page in a web part
I have a pivot table chart I would like to display on a Sharepoint page. Fast forward to 2mins 58sec in this Kalstrom video where he inserts an Excel chart in to a web page. I'd like to do the same.
...
- 2,319
1
vote
0
answers
87
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 ...
- 144
1
vote
0
answers
26
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 ...
- 11
0
votes
1
answer
1k
views
Excel web app won't load file with password protection
I have an Excel spreadsheet in a SP library that we'd like to use in an Excel web part. However, the spreadsheet wouldn't load in the web part/web app, and would only load externally with Excel. ...
- 144
0
votes
1
answer
40
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?
- 1
1
vote
1
answer
461
views
Linked images (cells copied from other spreadsheets pasted as linked image) do not show in Excel Web Acess Webpart on SharePoint page
I uploaded Excel file with multiple sheets and a Summary sheet(just another spreadsheet in same file) containing charts and cells pasted as "linked images" from other sheets in a document library in ...
- 90
2
votes
1
answer
2k
views
Excel Web Part Scroll Bar Defaults to middle of page
I placed an Excel Web Part on one of my pages. Whenever it loads, the bottom scroll bar (the one that goes left and right) is not at the far left side (where the default usually is), but it's in the ...
- 144
1
vote
0
answers
26
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 ...
- 11
2
votes
1
answer
72
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 ...
- 71
0
votes
2
answers
1k
views
Excel Web Access cannot open file
I have a site that was backed up and restored from one content database to a new content database using the below command.
Backup-SPSite -Identity https://sp.domain.org/sites/thesite -Path D:\backups\...
- 43.3k
0
votes
4
answers
3k
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 ...
- 101
0
votes
1
answer
303
views
Excel web part vs rest api
I want to DISPLAY multiple excel charts on a dashboard. I Do Not need the functionality of the excel web part. So, what I plan on doing is getting an image of the charts via the excel rest api and ...
- 125
0
votes
1
answer
1k
views
Sharepoint Online Excel Web Access web part refresh
Ok i have a sharepoint list with archive data about user performance (helpdesk environment). A flow runs when an item is added to the archive list which also adds the item to an excel document. I then ...
- 125
0
votes
1
answer
30
views
Access or Excel which is preferable when designing a SP site
I may have some difficulty explaining this. We are creating a SharePoint site to house an inventory. We will need read access to everyone and edit privs for a few. Currently, I have the data in an ...
0
votes
1
answer
561
views
Display SP Online list data as report in Excel Web Access Webpart
I have a SP Online list and I want to present this data as a report using Excel Web Access.
First is it possible to sync a SP Online list data to an excel file uploaded to SP document library as a ...
- 1,440
2
votes
1
answer
3k
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 ...
- 507
1
vote
1
answer
6k
views
SharePoint Online / Excel Web Access - auto refresh
I have 2 SP Lists exported to an Excel Workbook, which I saved in a library and added an Excel Web Access. The EWA is basically combining data from 2 lists, with. The workbook data connection is set ...
- 741
0
votes
1
answer
100
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 ...
- 741
1
vote
1
answer
115
views
Hide the Left Bar of XLViewer.aspx
I've the need to hide the "Edit in Excel" button of XLViewer.aspx of SharePoint 2013. Unfortunately in the organization I'm working is not possible to access to the SharePoint Server, so I cannot ...
- 11
4
votes
2
answers
224
views
SharePoint Limits
Hi I'm new to using SharePoint. I am looking to create a master excel which will feed into over 200 small excels sheets, all held on SharePoint. The smaller excels will be 'read only' and each ...
- 41
3
votes
1
answer
2k
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
1
answer
1k
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 ...
3
votes
1
answer
718
views
Conditional formatting not showing in Excel Web Part
I have applied conditional formatting to a Pivot Table. In the Excel desktop application, everything works fine. However, the conditional formatting does not appear in Excel Web Parts or Web Page ...
1
vote
1
answer
674
views
Excel web access part not working every time
Ok... I have one of those situations were there is no error and it all works (but just 10% of the time...)
I uploaded to sharepoint Online a simple xlsx file with just a simple 3x3 table with random ...
3
votes
1
answer
56
views
How to block columns in a file
How can I block specific columns so that they're visible for others, but people cannot edit this (specific) column in sharepoint? Thank you
0
votes
1
answer
741
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 ...
- 3,324
2
votes
1
answer
605
views
Not clickable cells with excel web part
I am using an excel web part on a Sharepoint 2013 page, displaying only a named item (basically a dynamic chart).
Is there any way to make the cells in the web part not clickable?
- 93
1
vote
0
answers
284
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
1
answer
5k
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 ...
- 147
1
vote
2
answers
684
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.
- 393
1
vote
0
answers
113
views
Copy paste the value from one cell to another based on condition using VBA [closed]
Below are my steps that I need to perform in excel. and I wanted to automate this as & when I run Macro :)
Background : I have already imported one sheet from another workbook and recorded the ...
- 101
0
votes
1
answer
123
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 ...
- 1
1
vote
0
answers
4k
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 ...
- 3,230
2
votes
0
answers
147
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,746
0
votes
1
answer
225
views
Is there a way to refresh an Excel Web Access Web Part without refreshing the whole page?
This is done through SharePoint Online.
The Excel Web Access Web Part is displaying a named item (a Chart specifically) from the Excel file (hosted in the Documents library). The data displayed in ...
- 238
1
vote
2
answers
4k
views
missing excel web access webpart in sharepoint online
I'm missing excel web access webpart in sharepoint online. I've google the topic and it says to enable "SharePoint Server Enterprise Site Collection Features" which i have done. However, i still ...
- 183
1
vote
1
answer
56
views
Excel Reporting linked to SharePoint
I'm currently having some issues linking Excel to my online calendar (list) whenever I choose the web as a data source and I enter the URL of the calendar I get the option to only import the entire ...
- 193
0
votes
1
answer
60
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!
- 99
1
vote
1
answer
41
views
Cannot add parameter to Excel Services
In the Browser View Options Parameters in Excel, why can't we select a desired named field when we click Add?
- 1,020
1
vote
1
answer
845
views
Excel web access chart losing formatting
A user has created a document in excel (works in 2007 and above). This document contains some simple data in one sheet and a chart in the other.
The problem is the chart which displays fine in excel, ...
- 41
0
votes
1
answer
109
views
Excel Online (many users but only one user is allowed to edit)
i have given many users have access to a excel sheet in Onedrive (excel online).
Thats ok.
Is it possible to give only one user access to sheet to edit. (the other users have to wait!)
I want that ...
- 1
3
votes
0
answers
111
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 ...
- 365
2
votes
1
answer
440
views
Is it possible to get data from excel file and create a pie chart and display on a sharepoint site?
Can we create a pie chart using excel reporting service.
I have a excel file (.xlsx) on my SharePoint document library.
I want to use excel data and create a pie chart but don't want to create this ...
1
vote
1
answer
214
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....
- 131
1
vote
1
answer
1k
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 ...
- 131