Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
1
vote
0answers
10 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 ...
0
votes
0answers
8 views
Update SharePoint List Using Excel VBA: Person or Group Field Data Type Error
I have successfully written code in VBA that allows me to import/link to a SharePoint list and to synchronize changes. I also have code that allows me to append a new row/recordset one at a time. ...
1
vote
0answers
18 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
10 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
20 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
8 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
30 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
38 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
27 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
31 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
28 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
65 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
33 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 ...
1
vote
2answers
151 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 ...
0
votes
1answer
21 views
hyperlink not working in excel web access sharepoint 2010
I posted an excel web access on my SharePoint, the file contain a list of hyperlinks to a Library of documents. the file uploaded fine, but all the hyperlinks are unaccesible. Is there a way to keep ...
1
vote
0answers
23 views
Excel documents failed to open in client
One user tried opening MS Office excel document which has macros in it, due to web app restriction he was able only to open document in client.
While opening, excel notified him as standard ribbon ...
0
votes
1answer
19 views
Can't share exported excel from SPO
So i've been wasting a lot of time trying to solve this with no luck.
Someone in my team created a excel file by using "Export to excel". On her PC it works perfectly, however...nobody else can ...
0
votes
0answers
15 views
Excel broken links - migrating from File storage to SharePoint 2016
Good day Guys
Do anyone have experience in using 3rd party tools to manage or fix links between excel sheets when moving them over from normal file storage to SharePoint 2016 on-premise.
it is my ...
0
votes
1answer
22 views
How to define how a file from Sharepoint is opened
On our company Sharepoint with have besides others a lot of Excel (xlsx) files. And we have Office 365 installed on our laptops, don't know whether this is important for this question.
When I click ...
1
vote
1answer
31 views
How can I make it so only certain users' changes are saved and everyone else's are discarded?
I have an excel database that we use to store product information. The admin of the sheet is the only person who should be able to edit the information on the sheet, which is easy to do through ...
1
vote
1answer
209 views
Cannot connect to SharePoint Online list from Excel
I'm trying to connect to a SharePoint Online list from Excel, and I keep getting the error "We couldn't authenticate with the credential provided".
I logged on to this list from Excel in the past ...
0
votes
1answer
111 views
Excel to SharePoint List: How to have a Choice column with multiple values?
I want to do the inverse of this post.
What do I need to type in my excel field to automatically create a Choice column in SharePoint with multi values when importing the Excel file via the Import ...
1
vote
1answer
57 views
Exporting item version check in comments
I have followed this answer to extract the list of versions in my document library to excel:
However, while the table lists all the versions it only displays (and repeats) the most recent check-in a ...
0
votes
1answer
18 views
Send Email When List is Created by uploading Rows from Excel File
I have a query about Sharepoint List in sending emails.
Help needed in creating the below requirements please -
Upload excel file contents having multiple rows/columns
Example-
Name City Country
...
3
votes
0answers
19 views
ADO.NET Data Services for SharePoint 2016?
As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source.
In researching how that can be done, I found ...
1
vote
1answer
30 views
Requirements for excel data refreshing
What are the requirements to be able to update data that came from Sharepoint (using Export to Excel button) by Excel "Refresh All" button?
On some machines I can refresh (when authentication prompt ...
0
votes
1answer
83 views
Can't update data Excel Online from Azure SQL datasource
Here's what I've done:
Created new Excel file on my desktop. Added connection to Azure SQL using database authentication. Read in a view.
Save this document to Sharepoint for my tenant. It's hosted ...
1
vote
0answers
22 views
Linking web parts of documents that are linked to other documents
I currently have a whiteboard where I have put up documents and charts as a visual representation. I would like to digitalize this board in SharePoint, so that I can make changes in the original ...
0
votes
0answers
37 views
How to import an Excel sheet to a List in SharePoint?
In this video i found the first way so easy and great.
but the problem is when an new record inserted in the excel sheet i have to create a new list with different name, so is there any way to update ...
0
votes
1answer
485 views
Connect excel to access to Sharepoint
Im trying to sync excel and Sharepoint so I can update an excel table and changes appears in sharepoint. Since I’m using 2016 versions for excel and Sharepoint I noticed it’s not as easy because I ...
0
votes
1answer
48 views
How to calculate value for calculated field in SharePoint using formula?
I have a date field called Start Date. I am using column validation to allow users to select only 4 date values, if they enter other than this they see a validation error.
So based on this Start Date ...
0
votes
1answer
40 views
How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?
I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list.
...
1
vote
0answers
27 views
Opening Excel files from SharePoint Online
When one of my users opens any Excel file from SharePoint Online in the client Excel seems to ask for their O365 credentials. The user enters their credentials (despite being signed in to Excel) but ...
1
vote
0answers
44 views
InfoPath button for Excel export
I want to add a button in InfoPath that will allow me to export the form into Excel. Is this possible? This is a requirement that client needs, and I have no idea how to do it without just saving the ...
0
votes
0answers
65 views
SharePoint List - Export Text Areas (Multiple lines of text) to Excel
On my task list, I have a few text areas that allow the user to explain what the issue is etc.
When exporting the data to an excel spreadsheet it won't actually show the entries, it shows the column ...
1
vote
0answers
5 views
In Powerpoint - browse window not displaying all information
In Powerpoint, Excel (native app, not web version) when I attempt to open files following the path:File >> Open >> Browse >> Sharepoint Pinned Folder ... the file names are missing, covered by a white ...
0
votes
1answer
36 views
If there any option inside sharepoint document libraries to allow multiple users to work simultaneously on the same .xls file tabs
We are working on a sharepoint 2013 team site. and inside the document library we have a .xls file which contain 5 tabs. so now oor users are asking if multiple users can work simultaneously on the ...
2
votes
0answers
16 views
Save file in same document set it is opened from
I have a request from a customer I am struggling with. Given is the following scenario:
SharePoint Server 2016
Whenever a new document set is created a specific Excel file is added to the document ...
0
votes
1answer
22 views
How do I create an formula in SharePoint Online?
hope you're well;
I would like to know how to create a formula for weekly in SharePoint online.
For example Tax year is April 2018 but I would like weekly number to be from Tax year.
0
votes
0answers
84 views
Download excel file on company sharepoint on to linux server
Want to setup a process where i can download a file on company sharepoint on to linux server.
Tried following
wget --http-user= --http-password= ""
I am able to connect to the server but for some ...
0
votes
0answers
56 views
Excel Online - Sharing workbook between two companies,
We're currently using Google Sheets to offer a online tracking system for one of our customers.
So for example, in columns A B C, we would enter specific details, and our customer would complete ...
1
vote
0answers
15 views
Linking a sharepoint list to Excel Online
I have a list in sharepoint. I've figured out how to extract it to Excel, and create a data connection. My question is, how do I extract it and create a data connection to Excel online/Excel in ...
0
votes
1answer
15 views
Export from Excel to CONTACT type list
I was able to export from an excel table to sharepoint, however it just creates a normal list. I want to import data to my CONTACTS LIST in sharepoint via excel, or maybe there is another way to do ...
1
vote
0answers
11 views
Search results show hidden tabs in excel
I have a problem that concerns the search function, I have it set to search only in a specific library, which works perfectly. However, it works a bit too well. It actually searches among my hidden ...
0
votes
0answers
69 views
Open Password SharePoint file with VBA?
I am trying to open a file we have on our SharePoint that has a password on it and must be checked out to edit. For some reason I keep having to enter the password even though it is supposed to be ...
0
votes
2answers
20 views
Excel in SharePoint - Refresh button directs to “Save As” which doesn't save changes
I use several Excel spreadsheets stored on our company's internal SharePoint site. When I open these in Excel ("Edit in Excel", not the Excel web app), then click the Refresh button at the top, it no ...
0
votes
1answer
480 views
Importing Spreadsheet to SharePoint 2013
when attempting to import a Spreadsheet from Excel to SP13, I get the error "List cannot be imported because SP Foundation-compatible spreadsheet is not installed or compatible with your browser.
0
votes
1answer
10 views
New to SharePoint 2013. Trying to create a user facing informational list
I am new to SP 2013, sorry if this is ridiculous or not feasible.
I work with automated calling and text messaging for a large organization. By default, a department is set to auto call, but can ...
0
votes
0answers
29 views
PowerPoint slides on SharePoint are deleted while opening from Excel with VBA
I run a VBA macro from Excel that has to open PowerPoint presentations on SharePoint, read something from a slide and write it to Excel.
The Makro ran on a Windows 10 VM for some weeks without any ...
0
votes
0answers
18 views
Ban users from modification when opening excel file
I'm using sharepoint 2013 and I have put a rich html that allows users who have the rights to put whatever they want. They can put for example an excel file. However in IE I have a problem, when users ...
