Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
15 views

Excel 365 in Teams/Sharepoint does not open the correct revision in one of my shared files (only one person in my team)

It is a very difficult to explain the issue, neither the IT person in my company is able to find the problem. We stored three .xlsx files in SharePoint. Me and my team has access to it and we update ...
0
votes
0answers
22 views

Excel file upload

When I upload an excel file in SharePoint, some of its tabs are missing when I access it in SharePoint. I have 12 tabs in my 2Mb excel file but only 9 appears when I open it in SharePoint. How can I ...
0
votes
1answer
16 views

Possible to use Co-Authoring via Excel Interop?

When editing an Excel workbook stored on SharePoint / OneDrive via Excel Interop (C# automation): can several agents co-author the file like multiple Excel users can? As a minimum, I require one ...
0
votes
1answer
54 views

Export sharepoint list item into excel using csom

I have a custom list. I have filtered with single item, based on ID. Now, I want to export that particular list item into Excel by CSOM coding. Please note, I don't want to export in CSV file format....
2
votes
1answer
27 views

Is there a shorthand way to save a sharepoint list as csv

With Google sheets one can save a (single) tab from the sheet as csv by adding ?format.csv to the document url. Is there a similar way for sharepoint lists?
0
votes
2answers
25 views

Copy and Pasting in SharePoint Excel - Without overwriting data?

This seems like such an easy, basic thing--but I can't for the life of me figure out how to do it. I just want to copy and paste cells from an Excel sheet into a SharePoint Excel WITHOUT overwriting ...
0
votes
0answers
12 views

Opening in desktop app deletes changes

I have been working on some very large spreadsheets in sharepoint. When i click edit in app it will load the spreadsheet but its lost some of the changes i have put in while still on the browser ...
0
votes
0answers
13 views

New files based on Excel templates in SharePoint

I'm currently trying to set up a SharePoint library and I encounter some problems using Excel templates. I've first tried to simply upload my template into the SharePoint folder, but opening it ...
0
votes
2answers
20 views

setting timer on the document viewing SharePoint online

We want to set a time out for viewing the document(Docx, pdf, excel files) in SharePoint based on the time.so, for example, we want the document to be activated for a certain user only for 3 hours ...
0
votes
0answers
15 views

How to update Metadata in Document Library from Excel Custom Properties?

I got really excited, when I learned how to get metadata out of an Excel file (instead of just word only). From all the instructions I have found, the only drawback seemed to be the oneway connection. ...
0
votes
0answers
11 views

Why Does Imported Excel Spreadsheet Numerical Data Appears as 1.47506e+006 Rather than 1475370

I've created an Excel spreadsheet with numerous 'general', 'number' and 'date' columns. I used the 'App' option of 'upload Excel Spreadsheet' to turn the Excel spreadsheet into a SP2013 list. Two of ...
0
votes
0answers
11 views

Why is my Excel Spreadsheet locked when I uploaded it onto SharePoint?

I locked certain columns in my Excel spreadsheet so that nobody would inadvertently put data in those columns. But I also made certain that specific columns in the spreadsheet were editable so that ...
0
votes
1answer
7 views

Using MS Flow with SharePoint and Teams to notify when changes are made to an Excel file?

I read that the Teams Files uses SharePoint as it's backend. There's an Excel file in Teams that we want people to be able to edit and then send an email and display in Teams Channel Chat when it ...
0
votes
0answers
11 views

Getting a document via ExcelRest: Request Entity Too Large

I'm currently attempting to get a file from my SharePoint library by making an AJAX query to ExcelRest. I'm able to return a document in this way, but when I attempt to get the document I need I get ...
0
votes
2answers
35 views

Export data from Sharepoint to excel

I have a little trouble with export data from SharePoint 2010 and Excel, i need get data from a SharePoint list, to do a sum of certain fields that are in the list. I prove the Power Query option for ...
1
vote
2answers
25 views

SharePoint Online - Updating dates in Excel

We are encountering strange issue while updating date column in SharePoint online excel files. When the dates are entered using dots in between the date and month( like 21.10 , 18.5),in excel it is ...
0
votes
3answers
41 views

How to feed a SharePoint List from an Excel table (Automatically)

We are trying to update an Excel list and have the updates automatically pop up in SharePoint. Is this possible and if so, how?
0
votes
1answer
30 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
35 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
17 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
22 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
20 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
1answer
88 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
12 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
136 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
80 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
51 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
36 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
16 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
7 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
21 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
43 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
55 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
48 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
997 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
46 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
13 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
22 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
27 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
31 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
25 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
117 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
175 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
16 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
41 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
393 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
528 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
16 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 ...