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

learn more… | top users | synonyms

0
votes
1answer
11 views

Customized Write Protection of Excel Forms on SharePoint

I have excel files on a SharePoint site which I am linking to the company's intranet. The reason we have the forms on SharePoint is that certain people need to update the forms regularly and we want ...
0
votes
1answer
27 views

User issues when opening the owssvr Exporting a List to Excel

I have created a List and Exported that list to Excel via owssvr. I have one User in our 15 person group that when she opens the owssver. One of the columns is supposed to show Last Name, First Name. ...
0
votes
0answers
7 views

Excel Online Office Add-In as a Service

In Google Sheets, using Apps Scripts, we can have a spreadsheet run as a service. We can write doGet and doPost methods in Apps Script which allow to handle HTTP Requests. Is this possible in Excel ...
0
votes
0answers
7 views

Excel Embeded View Editable fields?

I know how to embed excel on page so that users can see the data. I want users to be able to input updates on the page excel embed rather than opening the excel file. Is it possible?
0
votes
0answers
28 views

SharePoint App - How to Create/Populate Excel Spreadsheet Using JavaScript and List Data

I'm trying to create a Excel spreadsheet on a SharePoint app/add-in. The data that will populate it have been gathered from several SharePoint lists on the host web. Right now, I'm able to interact ...
0
votes
1answer
35 views

Hyperlink to Excel file in SharePoint Online: How to set by default that file opens in Excel (not Excel Online)?

I have put a hyperlink to an Excel file in our SharePoint (Online) to my company's intranet. How can I manage the file opens by default in Excel, not in Excel Online? Excel Online does not support ...
0
votes
0answers
22 views

Retaining the document version with “Export to Excel” delivers a runtime error

We have been working for a kinda long time now with a vba script for retaining the document version in an exported Excel spreadsheet. It was working pretty well, however, since a few days it delivers ...
0
votes
0answers
24 views

Hiding list items

In SharePoint 2007, I was able to create a column to hide an line in an Excel spreadsheet that was loaded into SharePoint. I cannot locate this option in SharePoint 2010... (we have not yet updated ...
0
votes
0answers
12 views

SharePoint Date not functioning in Excel?

I have a SharePoint list that has been exported into Excel as a XLSX file. When it is first exported, the SP date works great with Excel. I am in need of converting it to a column for month, quarter,...
0
votes
2answers
25 views

Excel->SharePoint

So I have a huge excel spreadsheet, with multiple lists and columns, how would I incorporate this into my SharePoint website as a new link? I know how to add an app, etc...but how do I add the ...
0
votes
1answer
21 views

excel upload with only specific columns

I'm trying to upload an Excel file to SharePoint, but i would like to only upload columns AL, B, and AU, and wondering if SharePoint has a way to do this, or if Excel has a way i can upload it to a ...
0
votes
1answer
50 views

Is there a way to get an Excel doc that uses a visual basic feature to show in SharePoint?

.com/GNU92.png First image shows the blue filled in date sections in the Excel doc. This is the desired display format of the doc. Second image shows what is displayed in SharePoint. No blue date ...
0
votes
0answers
23 views

SP2013 - Excel two way sync

So I've been asked to create a setup where the user can copy a rather large amount of info into an Excel file and then have it synced to the connected SP list. I've found several articles about the ...
0
votes
1answer
23 views

SP - Foreach Gridview cells before export in Excel to change TextFont

I want to change text in gridView cells before export in excel, because the text is big after export. This is my button to export in Excel: void btnToExcel_Click(object sender, EventArgs e) { ...
0
votes
0answers
11 views

How to build data connections across multiple Excel reports on SharePoint into a single file?

I have a dozen or so excel reports hosted on SharePoint in a template format, and I am trying to aggregate all of that information into a single master report. Because these files are on SharePoint I ...
0
votes
0answers
16 views

Is it possible to enter excel property easier for a new sheet in a document library?

I have a document Library (with only excel sheet) with the option of creating a new doc with a Template. The other property of the list consist of the title, a choice and a lookup on a list. When I ...
0
votes
3answers
48 views

Excel 2013 to Sharepoint List

How do I Insert, Update and delete Excel file to SharePoint lists. Automatically it has to create columns that are present in Excel sheet & whenever we add a record, update a record or delete a ...
0
votes
0answers
38 views

SharePoint Online Export to Excel

When I export a Multi-line (enhanced rich text) column to Excel a line-break gets appended before the content. This makes it looks like the column is empty in Excel until user clicks on the column ...
0
votes
0answers
30 views

Custom Document Information Panel works for Word, but not Powerpoint or Excel

I receive an 'unable to load form' error from my custom document information panel when trying to save an Excel or Powerpoint file into a SharePoint library. However, there is no error when I try to ...
0
votes
3answers
61 views

Are there list view url parameters to export to Excel?

I would like to automatically export a list view to Excel as a single click process. Are there parameters I can add to the list view url that will accomplish this? The list view is currently provided ...
0
votes
1answer
99 views

VBA code to determine whether a SharePoint file is checked out?

I've written a VBA program to examine each Excel workbook in a SharePoint folder and perhaps move it to another location. It turns out that rarely (but not never) a user is currently editing a ...
0
votes
0answers
30 views

SP2010 - Cannot Open (Certain) Excel Files in Browser

I have an odd problem. I have two reported issues from users on two separate site collections (same webapp). In both cases, CERTAIN excel files that previously opened in the browser, no longer will - ...
0
votes
1answer
21 views

How do you generate an email based off data in in an excel column?

Moving to SP online and trying to setup some work flows to simplify processes for employees, this particular scenario I have an employee who wants to auto-generate email(s) based on the dates in excel ...
0
votes
1answer
42 views

Export to Excel link I created not working in Chrome only (SharePoint 2010)

So after a ton of research and trying to figure out how to make this work, I've finally gotten frustrated enough to post here. I have to create a button that can export a list in SharePoint 2010 to ...
0
votes
0answers
11 views

Excel Hyperlink only reaches homepage

I'm having quite a unique issue with hyperlinks. I have an excel spreadsheet that is stored in our sharepoint server, inside the spreadsheet are hyperlinks that links to documents inside our ...
0
votes
1answer
72 views

Open File in a Sharepoint list via VBA

I want to open an excel file in a Sharepoint list via VBA. Here is my code: Sub OpenWB() Dim SummaryWB As Workbook Dim vrtSelectedItem As Variant With Application.FileDialog(msoFileDialogOpen) ....
0
votes
0answers
12 views

Excel file creation takes a long time

I have a SharePoint timer job for creating an Excel file, and it uses the ExcelWriter class described here for creating and adding the Excel file to a library. The timer job works fine on my ...
0
votes
1answer
38 views

Excel web access chart losing formatting

A user has created a document in excel (works in 2007 and above). This document contains some simple data in one sheet and a chart in the other. The problem is the chart which displays fine in excel, ...
0
votes
1answer
134 views

Error “Method Post of object IOWSPostData failed” when import Excel as new list

We are using SharePoint 2013 on-premise standard edition. Our users desktop have Office 2010 installed. Recently user test the import Excel spreadsheet into SharePoint 2013 list function. He tested ...
0
votes
1answer
30 views

Excel file not opening in sharepoint 2013

I am using SP2013 & created a site. I have used document library to store the documents in my site but the excel documents doesn't open it shows this error:- "We're sorry. We run into a problem ...
0
votes
1answer
112 views

Unable to save workbook in SharePoint Online / Office 365

We have a team site with a document library with 4 excel documents in it. When we want to edit the document using the Excel online editor we get an error: "Unable to save workbook". The changes are ...
0
votes
0answers
56 views

Two way sync with excel and sharepoint list

This is not a duplicate question for this. Requirement is different. I followed few articles and videos to enable two way sync between excel and sharepoint by using excel wss add-in. In this way we ...
0
votes
0answers
37 views

Error on importing Excel data into a datatable

Below is the function I used. But I receive the error message: external table not in the expected format As a solution provided at different sites I used it as commented below but I receive the ...
0
votes
1answer
21 views

Updating or refreshing a Web Access Web Part

I am working on a project where in SharePoint, I need to have a list of report names the left site section of a page and an Excel web access web part on the right site. The functionality should allow ...
0
votes
0answers
14 views

named image not in `workbook.getNamedItems()`

I need to be able to access an <img> after embedding my Excel dashboard into an html file. I have named the image in Excel, but it is not showing up in calls to ewa.getActiveWorkbook()....
0
votes
0answers
10 views

Have excel document automatically updated with scheduler

I have an excel document that currently goes out and looks for an updated log file. It then updates the data sheet and refreshes a pivot chart. this runs very smoothly on my local machine, but I want ...
0
votes
1answer
125 views

VLOOKUP data from a protected Excel file

I have two Excel files on SharePoint A source file which only I have permission to view/access and A public file that can be accessed by multiple people. There is a VLOOKUP in the "public file" ...
0
votes
0answers
29 views

Synchronize Sharepoint List with multiple Excel files

I have a list on SharePoint,and I would like to update that list from any excel sheet/file I create "Having same formatting of course". Can I achieve that? I know that you can create a List on ...
0
votes
0answers
25 views

SharePoint 2007 issue with Excel editable file link

I have an excel file that it editable by my team so it can be saved under the same file name. I recently created a link to it from another site, but it is not editable (it can't be checked out) so ...
0
votes
0answers
32 views

Enable Hyperlinks from Sharepoint in Excel

I have exported a SharePoint list to Excel using OData Feed connection, then uploaded the sheet to a SharePoint PowerPivot gallery. The SharePoint list have hyperlink fields, I want to enable them ...
0
votes
0answers
45 views

Sharepoint connection differences between Excel 2010 and Excel 2013

I'm new to SharePoint, so please bear with me. I'm connecting an Excel Spreadsheet to a SharePoint list for Read/Write access. I'm using the following connection string: (I replaced the URL and list ...
0
votes
1answer
119 views

Error Opening Tasks from Outlook

When I click on the "Open this task" in Outlook 2013. I get the following message: "Sorry We couldn't open https://...and the lists the URLs" I can open the task from the tasks list in SharePoint....
0
votes
0answers
17 views

Can I get sharepoint to review an excel workbook and send email

I have an excel workbook on sharepoint which contains a list of tasks for people with their due date. Is it possible to get sharepoint to examine the workbook, see which tasks are coming due (i.e. 6 ...
0
votes
0answers
14 views

External Data Refresh Failed

SharePoint BI Center, using OData feed to connect to using SharePoint API and retrieve list data then use it in excel to display power pivot chart. Error shows when refreshing the connection: ...
0
votes
0answers
18 views

Calculated column with Version data not refreshing, trying to export to Excel

I have a document library that I am exporting to Excel, and I am trying to output the Version number on the export sheet. The Version column is not available for export in Sharepoint 2010+ (we were ...
0
votes
3answers
75 views

Export mulltiple lists onto same sheet in Excel?

so I know we can export a single list to an Excel Spreadsheet, but is there a way export multiple lists on that same spreadsheet?
0
votes
0answers
62 views

Accessing files from SharePoint Library

I want to extract data from an Excel file stored in a SharePoint Library and dump the data in a SQL database. I have written different kinds of ETL processes in SSIS to achieve this with no luck. Here ...
0
votes
0answers
11 views

Excel online cell contents follows the mouse when I move out of the cell

I'm quite new to SharePoint and I've been editing text in excel tables via the "edit online" function. I've run into a problem when clicking a cell and editing the text. Sometimes after I've edited ...
0
votes
0answers
16 views

Microsoft MDS with Excel SharePoint error

We are trying to use the MDS for Excel Add-in to have users concurrently manage data. The tool is working except when we load the Excel file into SharePoint (we are not trying to host the Excel ...
0
votes
0answers
17 views

Different sharepoint services available after joining farm

I have 3 tier server connected to sharepoint farm. The problem here is that, the third server (latest) that i joined to the farm has different set of sharepoint service compared to the other 2 ...