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

learn more… | top users | synonyms

0
votes
1answer
44 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
1answer
24 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
49 views

How to import excel in SharePoint List programatically [duplicate]

How to import excel in SharePoint List programatically in SharePoint 2013. Excel having more than 40000 entry.
0
votes
0answers
12 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 ...
2
votes
1answer
78 views

Export list to Excel - 50'000 limit

We have a user that has a SP2013 list with nearly 100'000 items. In a previous SP2007 environment, they could export the entire list to excel. In SP2013, they are hitting a hard limit in Excel of 52'...
1
vote
1answer
15 views

Cannot add parameter to Excel Services

In the Browser View Options Parameters in Excel, why can't we select a desired named field when we click Add?
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
41 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
210 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
31 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
35 views

How to stop files from magically becoming Read Only?

I've had this document open since 8:00 AM when I came in to work. I occasionally make changes and save the document. Just now I tried to do the same but I get the following message: I'm getting ...
0
votes
1answer
143 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 ...
1
vote
1answer
54 views

How can I retrieve data from excel workbooks stored in SharePoint

I am creating a workflow on SharePoint online using SharePoint designer. In it, I would like an action that retrieves the contents of cell(s) in excel workbook in a SharePoint document library. Please ...
0
votes
0answers
67 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 ...
1
vote
1answer
57 views

Wrong datetime when exporting from sharepoint to excel

I'm using oDataFeed to retrieve sharepoint list data and place it in excel sheet. One of the fields in the list is date time field. I have noticed that the date is correct in the list but not on the ...
0
votes
1answer
28 views

Excel Online (many users but only one user is allowed to edit)

i have given many users have access to a excel sheet in Onedrive (excel online). Thats ok. Is it possible to give only one user access to sheet to edit. (the other users have to wait!) I want that ...
2
votes
2answers
850 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
1
vote
0answers
33 views

Excel cells randomly lost when uploading to sharepoint

A similar question has been asked, and I've tried the solution, but to no avail. Our stores have a spreadsheet, hosted on Sharepoint, that they add information to daily. Most stores simply keep it ...
0
votes
1answer
59 views

How can I get a value out of an excel workbook stored in SharePoint document library?

I am reposting this question asked about six years ago to see if I can get a less technical or more modern way of achieving the end result: I am trying to create an automated process that takes some ...
0
votes
0answers
42 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
22 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()....
1
vote
1answer
54 views

Import multiple excel spreadsheets to sharepoint 2010 lists

I have a user asking if its possible to import an excel file with multiple spreadsheets to a SharePoint 2010 solution? Each spreadsheet should be turned into one list. It is an autogenerated excel ...
0
votes
1answer
17 views

How to syncronize an Excel document in SharePoint with Access

I have an Excel Sheet stored in a SharePoint list, but this list will be updated every month. So some employees get the Access file and need to fill in their values, but they should just open the ...
2
votes
1answer
36 views

How to populate Excel 2013 sheets in SP2013 library with data from Access database on SP2013?

I'm new to Sharepoint. I may not use the right terminology and sound like an idiot. Please be kind. (I'm a former JEE developer. I understand the basic concepts. Just not sure how to translate them ...
0
votes
0answers
12 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
168 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
31 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 ...
2
votes
0answers
56 views

Sharepoint Excel file opens Read Only when edit is selected

A user on a team sharepoint who has contribute permissions is getting a 'read only' version of ONE of the files in a folder. All other users can open normally and edit. However, when this user selects ...
1
vote
0answers
26 views

Document ID URL opens excel File write locked

We have some issues cause our users often are using the document id link. So when a document id link of an excel file will be opened the excel file is not editable. There's also no possibility to get ...
4
votes
2answers
9k views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
1
vote
0answers
64 views

Power view in Excel Online, silverlight plug in

Hi I have an Excel document with Power View in Sharepoint Online and the different people that have access to the document (they open the document in an Android Tablet in Excel Online) have problems ...
0
votes
0answers
28 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 ...
2
votes
1answer
350 views

Can't crawl Excel 2003 files from SharePoint 2013

I have a SharePoint 2013 farm and am crawling the contents of a legacy SharePoint 2007 farm on the same network domain. I am getting the following error crawling Excel 2003 files (i.e. xls format) ...
1
vote
1answer
82 views

Can i download the Contoso Sample Files for SharePoint

I would like to download the Contoso sample files used in SharePoint 2013 training, is there any place that I can get them.
2
votes
1answer
93 views

How to Export a Document Library to Excel from SharePoint 2010 using a custom button?

I need to do the same as this little fantastic button in the sharepoint ribbon. It allows users to export a document library to an excel spreadsheet. I posted a screenshot below. I would like to ...
1
vote
2answers
1k views

Excel Online - Enter Array Formula

In Microsoft Excel entering an array formula requires using the keyboard combination: Ctrl Shift Enter How can I enter an array formula in Excel Online (the WebApp version of Excel). Is there ...
1
vote
0answers
33 views

Excel Web Access print button is disabled

The print button in the excel sheet that I have uploaded to a powerpivot gallery is not enabled. How do I enable it? File > Print show a print friendly view According to this msdn article ...
1
vote
0answers
69 views

Which library do I have to include to use SPListItem in VBA?

I want to read and modifiy SharePoint Lists with VBA from within Microsoft Excel 2013. Unfortunately I can not find which library I have to include to use those commands like described here: http://...
0
votes
1answer
145 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
33 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
48 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
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: ...
1
vote
1answer
52 views

Trying to publish and sync table from excel into sharepoint

I have created a table in excel and would like to sync it with sharepoint. I have downloaded SynchronizeWSSandExcel.xlam to allow me to publish and sync the table to sharepoint. When I click the ...
1
vote
0answers
69 views

Read the entire Excel file in atom format using Excel Services

I am trying to read Excel file stored in Document Library using Excel Services. I need to fetch the entire workbook content in a single request call. I have tried using Ranges using it like http://&...
2
votes
1answer
4k views

Creating a link between an Excel spreadsheet and a list

I have a query regarding something I’m not sure is possible. Hopefully somebody can tell me whether that is the case or not. We have an Excel document that we issue to suppliers after an audit, ...
3
votes
0answers
25 views

Excel webpart showing “Loading” but not showing the excel file

I am using an excel file which uses a dataconnection stored in dataconnection library. The dataconnection gets the data from sql server using Secure store and excel services. I am trying to use the ...
1
vote
1answer
1k views

Can't open office documents from SharePoint site

I'm using SharePoint 2013 and some users, I'll repeat, only SOME of them can't open office files in their client application (word, excel...). I don't know what is the problem because I can open ...
2
votes
1answer
62 views

From Excel 2010 is it possible to attach a PDF file to a list item.

I have the list item ID and I have the location of the PDF file, it is created using the excel sheet and now I want to attach it to a list item.