Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
21 views

Wrap Text in Sharepoint Site List

I am currently working on developing a List in Sharepoint. The top headers are quite long in length and I am trying to format the text so it takes up less space, such as wrapping? I have attached a ...
1
vote
1answer
14 views

How do you open a specific excel sheet from sharepoint URL

I have an excel with numerous sheets uploaded in sharepoint. How do I create a URL to access the specific sheet. I have referenced similar questions but it goes straight to download instead of going ...
2
votes
1answer
21 views

Sharepoint Excel Web Access Web Part double scrollbars

This has been very annoying for me. I searched for hours now in order to solve this. However I have not been able to find a satisfying solution. On a SP Webpart page I have added an Excel Web Access ...
0
votes
1answer
26 views

SharePoint Online - Excel File locked by User

We have a excel file in SP Online for which Co-authoring is enabled. But very often the file gets locked that too with a particular user account. The user (on whose name it displays as locked), he ...
0
votes
2answers
31 views

Error when trying to open excel in sharepoint 2016 using office online server

I am trying to open excel document in SharePoint 2016 using Office Online Server. I have installed and configured the Office Online Server on a separate server and configured the SharePoint to use the ...
1
vote
1answer
50 views

Extract data from excel file to sharepoint list once uploaded in library

We have a requirement that when an excel file will be uploaded into SharePoint document library, all its data should be captured and should be moved to separate lists accordingly. for example: if we ...
0
votes
1answer
14 views

SP 2010: Excel Calculation Services is not restarting

Excel Calculation Services is not restarting, and when researched, i found an error There was an error in communicating with Excel Calculation Services http://server:32843/...
0
votes
1answer
16 views

Adding object values to the correct SharePoint list columns---getting blank SharePoint rows

I'm parsing an Excel file and it's coming back as an array object. I want to add each object value into the correct SharePoint list column. I'm using POST to upload to info and the data is going ...
0
votes
0answers
22 views

Unable to open / upload excel files via SharePoint 2010 on Windows 10

Unable to open/upload excel (.xlsx) files via SharePoint 2010 on Windows 10. This is working on Windows 7 for them. It gives the error message while opening the file as: An error has occur please ...
0
votes
1answer
22 views

How can i find the Excel services URL for my file?

I'm trying to access through the Excel Rest API an excel file "My Excel File.xlsx", but regardless how I what excel services URL I use, I either get 404 or file does not exist or is deleted. This is ...
1
vote
0answers
71 views

How to automatically refresh Excel file with Microsoft Flow when source data is modified? [closed]

I have a master Excel file saved that consolidates financial data for different teams. The team data is updated in separate excels so that the teams can only see their specific excels, but it flows to ...
1
vote
0answers
40 views

Make SharePoint a pure WebDAV-server or avoid “We opened this workbook read-only from the server”

Don't stop reading - this is not the old "How can I stop Office opening my documents read-only from SharePoint"-question. Here's the background: We use SharePoint (2013 as a matter of fact, but I ...
0
votes
1answer
15 views

I can't see my image attachments (even url) when i export a list from sharepoint to excel

I have been trying to export a sharepoint list. The list has a column with image attachment, ( the images were loaded from powerapps linked to that particular sharepoint list). The issue is that when ...
0
votes
0answers
31 views

Cannot open IQY file in excel

After I export a list from Sharepoint and try to open up the iqy file I receive and error with the following:
0
votes
1answer
88 views

Update Excel sheet using ms flow

I have excel file inside document library in SharePoint. I want to update the excel sheet using MS Flow. I am passing static values via flow. (Ex Approval status: Approved & Approval Comments: ...
1
vote
2answers
19 views

Creating a change log for a spreadsheet in microsoft teams

There's a spreadsheet inside of microsoft teams. I'd like to create an audit//change log for it, so whenever something changes, I can find out who did it, and what it was before and after. Not quite ...
1
vote
0answers
26 views

REPOST - How can I search an Excel spreadsheet in SharePoint? [duplicate]

Looking to be able to search the contents of an Excel spreadsheet from the SharePoint mobile app. I have a spreadsheet with Postal Codes/Zip Codes with corresponding information. I would like to be ...
0
votes
1answer
51 views

How can I search an Excel spreadsheet in SharePoint?

Looking to be able to search an Excel spreadsheet from the SharePoint mobile app. I have a spreadsheet with Postal Codes/Zip Codes with corresponding information. I would like to be able to search as ...
0
votes
1answer
16 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
26 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
119 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
41 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
42 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
13 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
24 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
21 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
12 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
14 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
11 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
14 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
40 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
31 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
66 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
92 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
47 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
20 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
36 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
65 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
182 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
16 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
328 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
108 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
98 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
39 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
18 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
22 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
49 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
2 3 4 5
16