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]

Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

0
votes
1answer
20 views

Get Excel of SharePoint

I have a SharePoint DocLib. It contains an Excel spreadsheet I want to send every day at a specific time. Sending a mail every day... is not the problem. To get this done I'm using Flow to build an ...
0
votes
2answers
12 views

Connected Excel Spreadsheet to SharePoint List

Here is what I have done and what I am trying to do. I have a SharePoint list that I exported to Excel and then created a connection. When I add an item in the SharePoint list the new items are ...
0
votes
0answers
10 views

How to use powershell to merge specific tabs from a SharePoint document library that contains folders with list items that are Excel workbooks?

I have a requirement to merge specific 'export' tabs (worksheets) that are contained within folders that are within a SharePoint document library. The folders are 'top-level' items within list A. ...
0
votes
0answers
18 views

Implementation of auto refresh all for excel file in sharepoint

i have excel file stored in sharepont. Excel has power query connection to remote db. My goal is to setup automatic refresh of query connction in order to have up to date date in excel. Googling for ...
0
votes
1answer
45 views

Export all text field 'appended data' to excel from SharePoint list

In a situation when on text field I have option 'Append to existing text' checked How I can export data to excel to contain all the data from this field. The default export to excel is only exporting ...
0
votes
0answers
20 views

Excel Services Rest API in Worflow returns Forbidden responsecode

I am trying to access excel of a document library using rest service. I have a workflow which is retrieving data using rest api: The http request is: https://<>.sharepoint.com/sites/<>/_vti_bin/...
0
votes
0answers
9 views

is there a way to create SharePoint page with tabs to EXCEL and Power BI?

We have an EXCEL workbook in 0365 and a Power BI report. I would like my users to have a simple tab that allows them to switch between these two apps. I don't want them to open the full-blown ...
1
vote
1answer
26 views

SharePoint or Excel Issue?

I have a user that has an Excel file saved in a 2013 SharePoint on premises document library (versioning is not turned on). It is a .xls and he's been using it for some time and it's password ...
0
votes
1answer
25 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 ...
0
votes
0answers
10 views

Limit permission to a file via lookup

I'm sending out excel files to be signed and need to prevent users from opening other user excel . I can't set permission at folder/file level. The easiest workaround I can think off manually adding ...
0
votes
0answers
12 views

Excel Web Part - not getting Data validation dropdown list

I have excel Summary Page hosted through Web Part in SharePoint. The excel summary table linked to a cell that has drop down list Basis Data Validation.However, this drop down list is not visible when ...
0
votes
2answers
45 views

Export SharePoint online list to Excel

I know there is an OOTB functionality to export list into .iqy file that can be opened in Excel. But here we want to export the list using JSOM/REST to a file which has .xls format. I have gone ...
0
votes
0answers
10 views

How do I make the drop down list accessible in a SharePoint 2013 Excel web part?

I have an Excel spreadsheet that has built-in drop-down lists. I need the drop-down lists to be accessible through the web page and to save the data on the web part. The calculation/formula features ...
3
votes
1answer
74 views

Create an excel/word document using SPFX web part in SharePoint Online

I have one requirement about preparing excel and word document based on SharePoint list data and download it for user in SharePoint Online using SPFX web part. My question is: Can we create SPFx web ...
1
vote
1answer
131 views

Object doesn't support property or method 'readAsBinaryString' IE 11

I am using xlsx.core.min.js to upload excel files to SP and pass their contents to a new list. I have it working in Edge but it will not work in IE 11. The first console error I received was "Object ...
1
vote
1answer
11 views

Limiting editing access and setting up permissions so users can create new records but cant see the whole sheet

I am hoping that excel online can become a new system for entering in daily time for our company. id like to set it up so that our field crews can enter in their daily time on an excel online sheet ...
1
vote
1answer
62 views

SharePoint 2013 - Server is not responding/no connectivity to server issue when opening Excel files after removing support for TLS1.0/TLS1.1

We're having an issue that seems to be affecting Windows 7 users whereby they cannot click to open Excel files stored in a SharePoint 2013 Foundation document library. They get an error that either ...
0
votes
1answer
94 views

SharePoint 2010 export to excel:Cannot connect to server at this time

While exporting any document library in a SharePoint 2010 web application , getting following error: "Cannot connect to server at this time. Changes to your data cannot be saved." Export to ...
6
votes
0answers
91 views

Formula in spreadsheet being converted to a custom list

I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list. The spreadsheet contains the following columns: Received - This will be a number column with 0 decimal ...
0
votes
0answers
16 views

Excel file in SharePoint 2010 error

I have a user who is trying to open a Excel file and gets a error popup that says "The server copy of this document has been updated. Your changes conflict with changes made to the server copy. Save ...
1
vote
1answer
22 views

SP2013 NOTES column won't accept PASTE

I have another one of my lists that I need help with. This list has a NOTES section that displays a LINK that says "View Entries...". While this may be an obvious statement, I cannot paste to this ...
2
votes
1answer
125 views

SharePoint 2013 list does not export all data to Excel

hello guys I got SharePoint list with 13879 items and when I am trying to export data to Excel, it only exports part of this Data (352 items). also when I am scrolling List page to page it only shows ...
0
votes
0answers
49 views

Export SharePoint 2013 list big data to Excel

I have a SharePoint list with 13879 items, so when I am trying to export the list to Excel, data doesn't export. It is blank sheet and looks like this. (where column1, column2... are SharePoint list ...
2
votes
1answer
11 views

How generate link for office 365 online for ALL items in a folder, in a quickly way

i try to explain my issue. I created a folder in sharepoint then added some excel file (xls). Now i want to export the list of the link of all items, but NOT in that way https://mywebsite....
4
votes
2answers
217 views

Cannot Open an Office 2016 version 1812 document from Sharepoint Server 2016 Standard On Premises with either Form and Windows authentication methods

Until a few days ago, the "Open in Excel" function worked perfectly. After installing version 1812 (Build 11126.20169) they are no longer able to open office documents from sharepoint. I receive the ...
2
votes
2answers
77 views

Remove Lookup Columns ID's on list Excel Export

Has anyone come across this issue or dealt with ID numbers being exported from a lookup column? Is there a way that I can have the SharePoint list not export the numbers when I 'Excel export' the list?...
1
vote
1answer
44 views

SharePoint 2013 forcing Excel client to close/re-open

One of our users is experiencing an issue whereby opening an Excel file from a SharePoint 2013 library causes the client-program to close and reopen, loosing any previously open files (i.e. if Excel ...
1
vote
1answer
66 views

Permission Level Use Client Integration Features is not available

I have enabled the Client Integration Features like this: Central Admin > Manage Web applications > Select Web app > Ribbon: Authentication Providers > click Default Zone > Client Integration = "Yes" ...
1
vote
0answers
20 views

How to add document versions in Excel

Im looking for a way to add the document version in excel. Its quite easy in word with quick parts and SharePoint label. Is there a similar way to do so in Excel?
1
vote
0answers
16 views

How to handle formula references between excel workbooks kept in sharepoint/teams

Is there a recommended way to link workbooks that are kept in Sharepoint/Teams? I have a setup where many different projects have a spreadsheet for tracking various items and then one central ...
1
vote
0answers
86 views

How to delete excel temporary file “~$” in document library without delete permission

I have a document library which the normal user can only create and modify the files, they cannot delete them. But when they modify the files, there will be some temporary files "~$" being created in ...
0
votes
1answer
25 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. ...
0
votes
1answer
96 views

DropDown box with Numbers in PowerApps

I am trying to create drop down box in PowerApps that will have the numbers from 1 to 10. I want a user to select a number and the next screen would have the x amount of rows the user picked. so they ...
0
votes
1answer
13 views

Uploading Excel Datasource folder to SharePoint

I have a folder which contains an Excel data capture real time dashboard and form templates that are linked to the dashboard. How can I upload this folder to SharePoint and still maintain the ...
0
votes
1answer
89 views

The Excel client app “forgets” that an open file is checked out to the current user

Scenario An employee navigates to a document library that requires documents to be checked on our SharePoint 2016 on-premises environment. They then edit an Excel file (e.g. by right-clicking on the ...
0
votes
1answer
214 views

Append to existing text - Exporting to Excel

I have been looking online and can't really seem to find any clear information relating to this so thought I would pick all of your brains. I have a custom list with a multiple lines of text column ...
0
votes
2answers
99 views

Restrict downloading of documents from sharepoint with edit permissions

Can I restrict users from downloading documents if they have edit permissions in sharepoint? I have an excel file that my staff all need to collaborate on, but I do not want anyone to be able to ...
1
vote
1answer
35 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 ...
0
votes
1answer
33 views

How to import data into Excel from MS Access?

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint. Current as a PoC, I put the database on ...
1
vote
1answer
361 views

unable to refresh data in excel from sharepoint

I am using SharePoint 2010 and excel from office 2016. When i give export to excel from the SharePoint site, it works fine and loads the data in excel first time. But when i try refresh the data, it ...
1
vote
1answer
34 views

can we install a SharePoint 2013 KB in SharePoint 2016 environment

We are in process of migrating our SharePoint 2010 environment to 2016 . While we are having SiteMinder agent as authentication when we try to access the word/excel/ppt documents in Chrome browser it ...
2
votes
2answers
490 views

'Open In Excel' option is grayed out for .xlsm files in Sharepoint 2013

We know that excel files with macros and password protections are not supported to view in Browser using Office Web App / Excel Web App. In this SharePoint shows small dialogue where it has 'Open In ...
0
votes
1answer
46 views

hyperlink not working in excel web access sharepoint 2010

I posted an excel web access on my SharePoint, the file contain a list of hyperlinks to a Library of documents. the file uploaded fine, but all the hyperlinks are unaccesible. Is there a way to keep ...
1
vote
0answers
37 views

Excel documents failed to open in client

One user tried opening MS Office excel document which has macros in it, due to web app restriction he was able only to open document in client. While opening, excel notified him as standard ribbon ...
0
votes
1answer
20 views

Can't share exported excel from SPO

So i've been wasting a lot of time trying to solve this with no luck. Someone in my team created a excel file by using "Export to excel". On her PC it works perfectly, however...nobody else can ...
0
votes
1answer
22 views

How to define how a file from Sharepoint is opened

On our company Sharepoint with have besides others a lot of Excel (xlsx) files. And we have Office 365 installed on our laptops, don't know whether this is important for this question. When I click ...
1
vote
1answer
37 views

How can I make it so only certain users' changes are saved and everyone else's are discarded?

I have an excel database that we use to store product information. The admin of the sheet is the only person who should be able to edit the information on the sheet, which is easy to do through ...
1
vote
2answers
2k views

Cannot connect to SharePoint Online list from Excel

I'm trying to connect to a SharePoint Online list from Excel, and I keep getting the error "We couldn't authenticate with the credential provided". I logged on to this list from Excel in the past ...
0
votes
1answer
292 views

Excel to SharePoint List: How to have a Choice column with multiple values?

I want to do the inverse of this post. What do I need to type in my excel field to automatically create a Choice column in SharePoint with multi values when importing the Excel file via the Import ...
1
vote
1answer
123 views

Exporting item version check in comments

I have followed this answer to extract the list of versions in my document library to excel: However, while the table lists all the versions it only displays (and repeats) the most recent check-in a ...