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

learn more… | top users | synonyms

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
13 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 ...
0
votes
0answers
8 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
69 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
26 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
19 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
27 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
32 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
65 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
15 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
11 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
14 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
46 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
42 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
15 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
36 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
0answers
17 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
97 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
21 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 ...
0
votes
0answers
21 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
0answers
54 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 ...
0
votes
0answers
89 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
29 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
39 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 ...
0
votes
1answer
38 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 ...
0
votes
0answers
28 views

Create list with data from Excel files

I use SP 2013 and have a requirement to capture values from all the Excel files in SharePoint. All the files have different file names, but have the same sheets and need to refer to same cell in each ...
0
votes
0answers
25 views

SharePoint - saving excel library template

I have a requirement here which I would like to know if this is possible. Firstly I have setup a Document library to have a custom template which is in Excel. Basically its a financial template that ...
0
votes
1answer
57 views

How to export all list data from Web Scope to an excel file?

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked ...
0
votes
0answers
198 views

Unexpected error occurred import excel spreadsheet

I am trying to use the Import Spreadsheet app. I do not have multiple versions of Office installed or multiple languages. I have followed this and it did not work: SharePoint 2010 error when importing ...
0
votes
1answer
71 views

Excel connection. Issues with data getting into excel-table from SharePoint

I'm working on a project for a client. This client uses a form in SharePoint to enter and save data from certain projects into SharePoint lists. This data is setup to connect to an Excel file, that is ...
0
votes
0answers
11 views

Create a sharepoint page to validate Excel data and then combine into 1 output Excel file

I have a situation where a dozen or so users send me Excel data. I have a series of rules to validate the data. I open each Excel file and apply the validation rules. If the file contains errors, I ...
0
votes
0answers
21 views

Data Entered in Browser View Does Not Show in Excel Document

Data has been entered into an Excel document by selecting "Edit in Browser" and then edit in the Web Apps. This data can be viewed when you select view in browser or edit in browser, but it does ...
0
votes
0answers
47 views

Does Excel Web Apps support xls format - SharePoint 2013 with OWA

I have a sharepoint 2013 with OWA configured . But it seems .xls files aren't supported. Is this true? If yes is there an alternative option?
0
votes
0answers
49 views

Problems editing Excel only document in a SharePoint library

I have several users with Contributor accesses to a library. One user can open and edit all word and power point documents, but cannot edit an excel document. All the others with same permissions ...
0
votes
1answer
212 views

Unable to refresh data from sharepoint list in excel services

I've a SharePoint farm with Excel Application Services configured. I've created a Excel workbook with OData connection to SharePoint list. In Excel web view, I can't refresh data. Need help !
0
votes
0answers
26 views

Sharepoint List to Excel Update Excel Webpart

I have a list that is over the 5000 view threshold. The thought process was to export this to an Excel file, run Pivot Charts and then show the charts on a SharPoint Page using the Excel Webpart. ...
0
votes
0answers
43 views

Synchronize Excel 2013 to SharePoint 2013

I tried several ways to synchronize an Excel 2013 sheet to SharePoint 2013. For example download and see this MS Add-In It works once, but I got a problem report after saving the sheet and trying it ...
0
votes
0answers
101 views

Excel charts do not refresh on Sharepoint

It seems that the charts in Excel webpart do not refresh on Sharepoint if the series of the chart are connected to some named formulas / UDFs. It seems that anything beyond a simple name connected to ...
0
votes
0answers
98 views

Anonymous Users cannot open XLSX/PPTX files from a SharePoint 2010 document library

Scenario :- Environment :- SharePoint 2010 we have a Site Collection and sub-site which has complete Anonymous Access and all the Document Libraries under the sub-site are given View Items ...
0
votes
1answer
16 views

importing excel onto sharepoint and use the data to build reports?

Is it possible to do this with sharepoint? I have read quite a few introductory articles that seems to hint on the possibly of acheiving this, but I couldn't find any tutorials on it. Can someone ...
0
votes
0answers
92 views

Office Web Apps + SP2013: Why is only Excel opening in browser by default?

I just installed Office Web Apps and configured it to SharePoint 2013, but only Excel seems to open in the browser by default. Word, PowerPoint, PDF etc. opens in client application. Preview works ...
0
votes
0answers
33 views

“This workbook cannot be opened…” on 64bit IE

So, The message when trying to open an excel file from SharePoint goes like this This happens when I use IE, specifically the 64bit version. If I use the 32bit version, it runs fine. Now, this is ...
0
votes
0answers
35 views

Sharepoint Mutiple Lists, Excel import & export questions

Here are a few questions i have regarding SharePoint & Excel - Using 2010 I have created a list that is an "Order Intake Forum" It asks the user various questions in order to place an order ...
0
votes
2answers
283 views

Cut and Paste not working in Datasheet view Sharepoint 2013 O365

I have a question regarding an unusual error that I can't seem to resolve. I have a document library and am trying to cut and paste metadata from an excel 2013 spreadsheet into columns in a datasheet ...
0
votes
0answers
24 views

Excel filename affects SharePoint ability to open in browser?

SharePoint version 4 (14.0.0.7137) says "an error has occurred" when attempting to 'view in browser' an Excel file located in a library. If that same Excel file is renamed using the Edit Properties ...
0
votes
0answers
330 views

We can't do that because the file is no longer checked out or has been deleted

I have an issue with Sharepoint 2010 and Excel 2013 i get the error message: We can't do that because the file is no longer checked out or has been deleted This happens when: I create an new excel ...