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

learn more… | top users | synonyms

0
votes
0answers
6 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
19 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
21 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 ...
1
vote
0answers
19 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 ...
0
votes
0answers
8 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
26 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
13 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
18 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
40 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
11 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
31 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: ...
0
votes
0answers
20 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
21 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
28 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 ...
0
votes
0answers
13 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
7 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
44 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
22 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 ...
3
votes
0answers
14 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
34 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
53 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
19 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
12 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
45 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
24 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
31 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
14 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
9 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
11 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
26 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 ...
0
votes
1answer
218 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 ...
0
votes
0answers
15 views

Problem connecting Excel sheet to Excel Web App

I am trying to Connect to Excel sheet in a SharePoint library using the Excel Web app and I am getting the following error, I have attached a screenshot for the same. Cannot complete this ...
0
votes
1answer
49 views

How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part

The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
0
votes
0answers
19 views

Newly Added Files Cannot be Opened from VBA?

I am using the following VBA code to open a file on SharePoint. This code works just fine for any other file on SharePoint but I cannot get it to work on one specific file. I recently added this ...
0
votes
1answer
9 views

Deleting SharePoint files via Excel

At work we have a spreadsheet of accounts that after a certain amount of time need to be deleted. So far the only way we have to do this is by manually going through each and every account and hitting ...
1
vote
1answer
48 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
1
vote
0answers
83 views

SharePoint 2010 and Excel 2016 incompatibility

Situation: You check out/open a document or spreadsheet from SharePoint 2010 (Intranet) using the actual Office application (not in the browser). On attempting to save, you will either get a ...
0
votes
1answer
56 views

Extract a list to Excel

How do I extract a SharePoint 2013 list to Excel meeting this requirements? I cannot use SharePoint Designer. I do not want to use the export option as I want to be able to call this outside of ...
1
vote
1answer
57 views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
0
votes
0answers
19 views

Cannot click on anywhere in Excel file opened in SharePoint 2013

I am unable to click on Menu Bar or Worksheet when I open my Excel file in SharePoint Server 2013. When I click, it just nothing happens at all. I am using IE. I don't think the problem is with ...
0
votes
1answer
102 views

SharePoint 2010 Excel xlsm file won't save to local computer

I'm having a problem troubleshooting an issue on SharePoint 2010. Users with Read only permissions via NT Authority/Authenticated users are having problems saving a local copy of a xlsm as a local ...
0
votes
0answers
41 views

Export to excel not showing all rows

We have a very large list and a user is exporting a filtered view to Excel, the view has 18,000 items, give or take, and he is only getting 16,000 items exactly I want to know if it is a problem with ...
1
vote
1answer
69 views

Sharepoint 2010 Slow to open documents

Today users started reporting that they could not open Excel files located on our SharePoint site via IE. When a file is clicked, Excel launches and in the bottom a progress bar says "Downloading: ...
1
vote
1answer
19 views

Doing calculations in Excel Online with user permission “View Only”

I want to share Excel files in a SharePoint library. The users shall only be able to open the files in "Excel Online", but not to download them or the open them offline. Also the original file ...
0
votes
0answers
60 views

export specific columns/fields of list to Excell and not the whole list. How?

End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns. I've created "another ...
0
votes
1answer
26 views

Roles and analysis of results Excel Surveys

I have a excel survey created in a SharePoint page. Right now if I share the link, anyone can fill in the survey. Can I somehow restricted so that only users with an account on the intranet, or ...
0
votes
0answers
30 views

Save the modified date from sharepoint to sharepoint drive

I got this VBA Excel document where I map a network drive which is the sharepoint drive folder that I have admin rights for. The problem is that when people publish their document then the sharepoint ...
1
vote
2answers
252 views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
0
votes
1answer
33 views

How to Output Specific Columns to Excel

I have a custom application page that pulls data from one specific list and exports to excel. Below is the code that performs the work: <script runat="server"> protected void ...