Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
0
votes
0answers
10 views
List form send data to excel in Documentlibrary
Is it possible to send data from a Sharepoint list form to an excel file that is stored in Documentlibrary. If it is possible how should I do it? I couldnt find any tutorial on this matter.
Thanks,
0
votes
0answers
13 views
“JavaScript required” error when opening an Excel sheet from SharePoint
I have created a SharePoint website with a document library to allow my team members to share Excel files more easily.
When they open Excel sheets, they are redirected to the Excel client app since ...
0
votes
0answers
19 views
“File Viewer” modern web part zoom level for an excel sheet
I have an excel sheet inside my PC, and I set its zoom to 50% and save it.
Then I uploaded it to our SharePoint online document library >> then I show it inside a modern page using "File Viewer" ...
0
votes
0answers
9 views
EXCEL import: share point calculated field source columns are blank while others can see data in them
I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no ...
0
votes
0answers
9 views
Lock Excel Sharepoint linked to Microsoft forms
I was able to create a Microsoft form linked to an excel sheet stored in sharepoint. Multiple users will have access to the sheet. I want to lock one column with a password. I select the edit range ...
0
votes
2answers
27 views
Error while trying to “Export to Excel” a custom list in SharePoint Online
I am using SharePoint Online and Excel 2016. When I try to "Export to Excel" a custom list, I get the following errors:
My version of Excel 2016 comes from Microsoft Office Professional Plus 2016.
I ...
0
votes
1answer
44 views
Sharepoint Document Library Hyperlink Metadata Using Excel VBA
I have VBA code written for my Excel document. This code saves the workbook in Sharepoint site and sets the metadata for the document library that the workbook is saved into.
Working code to set ...
0
votes
0answers
13 views
Excel hyperlink to sharepoint documents
I have a problem.
Within my company, we had a system to make an excel file and create hyperlinks to the file name. We made it a little simpler by making another sheet with the link to the files so ...
0
votes
1answer
21 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
20 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
12 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
28 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
105 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
30 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
44 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
29 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
17 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
57 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
22 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
160 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
315 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
14 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
86 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
219 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
95 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
24 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
149 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
54 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
13 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
235 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
135 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
92 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
22 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
17 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
118 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
37 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
139 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
14 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
109 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
305 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
138 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
38 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
475 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
633 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 ...
