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

learn more… | top users | synonyms

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
137 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
33 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
113 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
42 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 ...
1
vote
1answer
40 views

Can SharePoint view in browser docx/pptx/xlsx taken from external sources?

I've noticed SharePoint project (2013 atleast) can view in browser Excel, PowerPoint, and Word document files, which is great. So when you create an html5 web app on SharePoint, you can link the docx/...
0
votes
0answers
58 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
51 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
24 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 ...
1
vote
0answers
29 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
54 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
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()....
1
vote
1answer
50 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 ...
2
votes
1answer
33 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
11 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
126 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 ...
2
votes
0answers
54 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
23 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 ...
1
vote
0answers
56 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
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 ...
1
vote
1answer
61 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
82 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
0answers
26 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
62 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
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
120 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: ...
1
vote
1answer
51 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
62 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://&...
3
votes
0answers
22 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 ...
2
votes
1answer
56 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.
3
votes
1answer
90 views

how to export BI report to excel

We deployed bi dashboards in our web application using the performance point service and it enable annonymous acess for users without login they can view. but when they trying to export it ask ...
3
votes
1answer
46 views

Can you prevent Excel for adjusting column widths when doing an export from sharepoint?

My list and reports are fairly large. Now that I have converted the MS Office 2013 I've noticed everytime I try to do an export from my SharePoint lists even a small export it takes a long time to ...
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 ...
1
vote
1answer
57 views

how to export to Excel from a webpart

I am using Sharepoint Server 2010, and need to use OOTB features only. I have created a page with a web part on it, using a view from my list. The webpart works on parameters entered on the page. When ...
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 ...
2
votes
0answers
16 views

Synching select rows from an Excel spreadsheet into a SharePoint 2013 List?

I know you can connect Excel and SharePoint 2013, but is there a way to "selectively" sync data from an Excel Spreadsheet into a SharePoint List? Basically, we have a master spreadsheet where each ...
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 ...
0
votes
1answer
64 views

How to send automatically triggered mails from SharePoint with dynamically acquired Excel table data?

I am trying to figure out how to make a SharePoint workflow send a email containing specific Excel data from a file on this respective SharePoint. Maybe there is a far better way, i do not know. For ...
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 ...