Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
738
questions
0
votes
1answer
16 views
Updating Sharepoint using Flow and Excel
I have a SharePoint list and want to update a specific field using Excel and Flow.
I understand how to pull the Excel table (using Get List Rows Present) and then to pull up the Update Item action ...
0
votes
3answers
23 views
Formula not working in Excel to move to SharePoint calculated column
I have two conditions that need to be met to return a date in another column
Here is my formula
=IF(ISNUMBER(SEARCH("Rejected",A2)) =IF(isblank,"","Today"))
I can't get this to work, if i do them ...
0
votes
1answer
15 views
Items showing up in export that aren't in the list
When I export my list from SharePoint, there are extra items showing up in the excel sheet that are not in the list. Why is this?
0
votes
2answers
16 views
Pulling data from multiple excel files hosted on Sharepoint
I have a load of excel files (consistent format, but with different content) that I would like to pull data from into one master file. All source files are saved on Sharepoint in one folder, and the ...
0
votes
1answer
10 views
Excel Document Crashes In Microsoft Teams while Co-authoring Office 365
While editing Excel document in MS Teams, The excel document we are collaborating on crashes and all the work is lost. I have attached screenshots.
Any suggestion please? Is this a known issue?
0
votes
0answers
9 views
VBA Excel Retrieve SharePoint User Number By Name (not User Information List)
Below, I've got a little job to insert a record into a SharePoint list. The Requestor field is a "Person or Group" type field, and in the code, the...
rst![Project] = Sheets("Sheet2").Range("B2")....
0
votes
0answers
10 views
Appending log data in shared sharepoint file with write-only permissions?
I need to write live log data, in line-by-line csv format, to a file in Sharepoint.
Ideally, my permissions will be to only append/write, and not read.
Very simple:
Date, time, plain text columns C,D,...
0
votes
1answer
30 views
Export Excel data to exisitng sharepoint list using jquery [duplicate]
can we build a solution in jquery where we can export excel data to existing sharepoint list number of column in excel will be 56 or more with 5000 rows , i have to use on JSOM
0
votes
3answers
58 views
Export table to exisiting sharepoint list from excel
Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
0
votes
3answers
34 views
SharePoint Custom List with Multiple choices columns export to Excel
Is it possible to export multiple choices columns in a SharePoint custom list to an excel spreadsheet and that the list keeps its values in a multiple choice format?
0
votes
1answer
25 views
Export SharePoint List to Excel
I have been getting an error when I try to export a Contacts list from our SharePoint online environment to excel. It downloads a query file but says "Cannot connect to the server at this time. ...
0
votes
1answer
14 views
How to download original Document with macros while being in Excel Online?
I open an Excel file with macros in Excel Online, where I (correctly) get the message, the file contains unsupported features. But out of this situation I'm not able to download the original file with ...
0
votes
0answers
5 views
using excel macros to get a value in a sharepoint form
I have a form in share point that has a field "labor cost"
I have an excel document that calculates that value.
I want to be able to have the labor cost field calculate based on values in the forms(...
0
votes
0answers
20 views
Sharepoint, Access, Excel two way connected database
I am trying to create a Database system that uses an Access Database of which can be updated from Excel, The Users (Multiple), Access Database & Excel spreadsheet are all on a Sharepoint company ...
0
votes
1answer
37 views
Checked Out Required to modified the server work book
We are using SharePoint 2013, users is having office 2016, Now in Document Library --> Open with Explorer -> Right clicked and created Excel Document --> Double clicked to add data in excel. Now here ...
1
vote
2answers
36 views
Excel/Powershell to extract substring from a URL
I want to extract root URL from full URL. how to extract that based on number of "/" in that.
for example:
https://teams.SharePoint.com/sites/site/communities/subsite
from this URL i want to ...
1
vote
1answer
35 views
sharepoint on premise losing excel changes
SharePoint 2013 on premise is not always saving changes in Excel to the point that some colleagues are losing hours of work. Why does this keep happening?
May I add, that the drafts can be see in ...
1
vote
1answer
228 views
Conversion of csv file to xlsx via Flow or SharePoint
I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how ...
0
votes
1answer
17 views
Giving one of two options
I am really new to all of this, but I'm trying to edit a column with the following:
=OR(LEFT([Ticket Number],6)
="TASK00",LEN([Ticket Number])=0)
where the user is required to enter their ticket ...
1
vote
1answer
20 views
Restrict partial access in an excel shared file in sharepoint
I have an excel file that has many users but I would like to restrict access to sort or modify the format. Is this possible?
Update:
This is a shared file with about 200 employees adding new data ...
1
vote
1answer
12 views
Display Excel data as choices on sharepoint online
I would like to display choices for one of my columns within my list that can only be found on an excel file (for data harmonization/standardization). How may I achieve this? Can I upload the excel ...
0
votes
1answer
17 views
How can I convert an excel workbook with 6 different sheets to a sharepoint list?
Should unify all the sheets into one giant list ? I would be great if there was some mechanism to combine the sheets into one entity but yet keep them separate within that entity?
0
votes
1answer
21 views
Import whole workbook onto a sharepoint list
Is it possible to import a whole workbook onto a sharepoint list? Or have them tabbed somehow so as to use them later on on power apps?
0
votes
0answers
24 views
Looping through rst.Fields
Pardon any errors my VBA skills are not great.
So, I'm attempting to upload excel data to a SharePoint list and I followed some tutorials to understand how I can accomplish this within a macro and I'...
1
vote
1answer
28 views
Import Spreadsheet to Datasheet SharePoint with calculating columns
Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it'...
0
votes
1answer
24 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
59 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
104 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
15 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
18 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
142 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
261 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
15 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
24 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
24 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
17 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
128 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
2answers
361 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
43 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
62 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
39 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
13 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
34 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
244 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
79 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
412 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
767 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
15 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
160 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 ...
