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
14 views

Excel file issues in OneDrive

I was working on an excel file from past 1 week. This file was saved only on One drive and not on my disk. Till yesterday everything was fine. But today when I open the file, everything I worked from ...
0
votes
0answers
4 views

REST or ADODB? What provides the best performance of creating an Excel VBA tool?

I’m creating a small Excel VBA tool that performs basic CRUD operations to SharePoint lists. Ha-ha, I know, probably a terrible solution but it’s all we have or allowed to work with at the moment. I’...
0
votes
0answers
14 views

Display SharePoint Online document property in Excel cell

I'm attempting to access and display a SharePoint property I've set for Review Date of an Excel document. The property is visible in a column in the Document Library. This is easy to do in Word by ...
0
votes
2answers
43 views

Getting data from SharePoint Online in Excel 2013 spreadsheet - unable to refresh one or more data connections (when refreshing in browser)

Environment SharePoint Online Excel 2013 with Power Query Add In Desired Behaviour When I click 'Refresh All Connections' in a spreadsheet file in a SharePoint folder: data from 2 x SharePoint ...
0
votes
1answer
10 views

Excel import OData feed URL from SharePoint 2016 get 401 error

I want to establish an OData datafeed in Excel 2013 to connect to a SharePoint 2016 list. In the Excel, data tab -> from other source -> from OData datafeed. Then I input our SP2016 url: https://...
0
votes
0answers
10 views

I need to get the excel file which is contained within the collection based on listdata.svc call

I am having trouble with using an excel document which is part of a Documents Collection in SharePoint. In SSIS I have created an OData connection which points to: https://company.sharepoint.com/sites/...
0
votes
1answer
48 views

How to enable ‘Forms for Excel’ in SharePoint/Office 365

I am an Office 365 global administrator, looking after two SharePoint sites. One has menu items for Forms, but the other does not. The site that works is new, created since we started using Forms. ...
0
votes
0answers
6 views

Complex Drop List Formula

I have a dropdown list named “Frequency” on column F with options as follow:- Weekly Biweekly Monthly 2x per week Now I want to create a calculated column named “Next outreach Date” (Column H) ...
0
votes
0answers
21 views

Wrap Text not working in SharePoint Excel

Text just appears squished instead of wrapping to the next line. Oddly when I download the file locally the wrapping works perfectly, just in SharePoint does it behave this way.
0
votes
0answers
4 views

Saving and Renaming Excel file Does Not remove 256 user Error

I'm hoping someone might be able to help me. I have read the other post here created a few years ago regarding this same issue. Unfortunately, I've tried saving the Excel file locally, renaming, and ...
0
votes
1answer
21 views

Can I embed an excel file in a sharepoint page so it can be used, but not downloaded?

I have an instructor who teaches excel, and wishes to administer an exam, but doesn't want the students to be able to download the file. Is there a quick way to embed the excel document into a ...
0
votes
2answers
29 views

Powershell : Read excel file data in document library and then modify it and upload it back using powershell in SharePoint Online

I am looking for powershell solution which will read xml file in document library and loop throgh all rows and add/modify rows/columns on the excel file and upload it back to sharepoint. Tried ...
0
votes
0answers
29 views

What is the correct API and node SDK to append rows to Excel in Sharepoint Online?

I've been asked if I can change from appending row data from Google Sheets as I currently am, to "an Excel sheet in Sharepoint [online]". Really very simple - "date, time, event" appended to ...
0
votes
1answer
11 views

Update URL's link Inside Office (docx, xlsx) documents

We need to change the root of our SharePoint 2013 Document Management site collection due to a company ownership change from Sharepoint.acb.net to Sharepoint.xyz.net. I configured everything using the ...
0
votes
1answer
26 views

Sharepoint: Mass Create “Link to Documents” from List in Excel

Background: We have a running index of files within an Excel workbook that we use to list and maintain our files and related attributes/categories. This workbook includes a data column with links to ...
0
votes
0answers
5 views

Excel doesn't update file, when file is still open after checkin

we have the following Setting: We're using SharePoint 2013 on Premise and Microsoft Office Professional Plus 2016. Now here is the Problem: I have an Excel file in a Document library. User A opens ...
0
votes
1answer
27 views

Need to create a microsoft flow to trigger email based on the email address mentioned in the excel row

I am working on an excel which contains Name, Amount, quantity, email address and a dropdown - Send Email - Yes/No. I am trying to build a microsoft flow where I want to trigger an email when a user ...
0
votes
0answers
17 views

Upload all folder files to SharePoint document library

I am working on code which will upload all ShareDrive folder files to SharePoint Document library: I need this to be done via VBA I have an excel, at A2, there would be ShareDrive Path and A3 would ...
0
votes
0answers
30 views

How to save Excel w/Macros to SharePoint

Good Day, I've reviewed the following questions Excel Macros in SharePoint and How to handle Excel sheets with macros and am still stumped. So... We have an Excel Spreadsheet that is full of macros ...
0
votes
0answers
13 views

blank page when i open Excel sheet on SharePoint online

when I open an excel sheet on my SharePoint online site (open in browser ), it gives me a blank page it's not even download -I am the owner of the site (Team site) -checked different browsers \ ...
0
votes
0answers
30 views

Export to Excel displays no results

I am new to SharePoint (2007 version) so please excuse any basic errors. I have created a survey in SharePoint that has a mixture of yes/no, multiple choice and free form text answers. Prior to ...
0
votes
0answers
15 views

Excel VBA to fetch Views information from SharePoint Document Library

I need to fetch the List of views and view information in SharePoint Library.How can I achieve it using Excel VBA. I tried to search around, but was not able to find relevant solution. Thanks in ...
1
vote
1answer
49 views

Using Power Automate to Export Outlook .xlsx Attachment to SharePoint List

I'm in the middle of setting up an automated flow using Microsoft Power Automate and I have some questions. I'm seeking to extract an .xlsx file from an Outlook email attachment and have the data from ...
0
votes
1answer
11 views

Share just one of multiple spreadsheet saved in excel on Sharepoint

Hi I have a excel file saved on the sharepoint and it has 5 spreadsheet. I want to give people access just to one of the spreasheets saved on the same excel file, is that possible?
0
votes
2answers
140 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
91 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
32 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
35 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
62 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
58 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
15 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
20 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
29 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
29 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
534 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
81 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
19 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
97 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
705 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
49 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
92 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
18 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
23 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
34 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
308 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
51 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
88 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
42 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 ...

1
2 3 4 5
16