Stack Exchange Network

Stack Exchange network consists of 174 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.

2
votes
1answer
32 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
48 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
8 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
24 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
21 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
89 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
13 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
21 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
101 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
39 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
178 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
38 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
40 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
33 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
12 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
41 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
15 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
48 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
11 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
59 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
103 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
46 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
32 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
31 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
195 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 ...
1
vote
2answers
304 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
32 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
29 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
34 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
857 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
211 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
97 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 ...
0
votes
1answer
18 views

Send Email When List is Created by uploading Rows from Excel File

I have a query about Sharepoint List in sending emails. Help needed in creating the below requirements please - Upload excel file contents having multiple rows/columns Example- Name City Country ...
3
votes
0answers
21 views

ADO.NET Data Services for SharePoint 2016?

As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source. In researching how that can be done, I found ...
1
vote
1answer
35 views

Requirements for excel data refreshing

What are the requirements to be able to update data that came from Sharepoint (using Export to Excel button) by Excel "Refresh All" button? On some machines I can refresh (when authentication prompt ...
0
votes
1answer
125 views

Can't update data Excel Online from Azure SQL datasource

Here's what I've done: Created new Excel file on my desktop. Added connection to Azure SQL using database authentication. Read in a view. Save this document to Sharepoint for my tenant. It's hosted ...
1
vote
0answers
22 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 ...
0
votes
0answers
44 views

How to import an Excel sheet to a List in SharePoint?

In this video i found the first way so easy and great. but the problem is when an new record inserted in the excel sheet i have to create a new list with different name, so is there any way to update ...
0
votes
1answer
792 views

Connect excel to access to Sharepoint

Im trying to sync excel and Sharepoint so I can update an excel table and changes appears in sharepoint. Since I’m using 2016 versions for excel and Sharepoint I noticed it’s not as easy because I ...
0
votes
1answer
113 views

How to calculate value for calculated field in SharePoint using formula?

I have a date field called Start Date. I am using column validation to allow users to select only 4 date values, if they enter other than this they see a validation error. So based on this Start Date ...
0
votes
1answer
70 views

How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?

I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list. ...
1
vote
0answers
32 views

Opening Excel files from SharePoint Online

When one of my users opens any Excel file from SharePoint Online in the client Excel seems to ask for their O365 credentials. The user enters their credentials (despite being signed in to Excel) but ...
1
vote
0answers
65 views

InfoPath button for Excel export

I want to add a button in InfoPath that will allow me to export the form into Excel. Is this possible? This is a requirement that client needs, and I have no idea how to do it without just saving the ...
0
votes
0answers
91 views

SharePoint List - Export Text Areas (Multiple lines of text) to Excel

On my task list, I have a few text areas that allow the user to explain what the issue is etc. When exporting the data to an excel spreadsheet it won't actually show the entries, it shows the column ...
1
vote
0answers
5 views

In Powerpoint - browse window not displaying all information

In Powerpoint, Excel (native app, not web version) when I attempt to open files following the path:File >> Open >> Browse >> Sharepoint Pinned Folder ... the file names are missing, covered by a white ...