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

learn more… | top users | synonyms

0
votes
0answers
29 views

Syncing Sharepoint 2013 List from Excel 2010 spreadsheet?

So i'm trying to figure out a way in which I can append items within my SharePoint list by inserting the data from an Excel Spreadsheet. However, the SharePoint list has additional columns which are ...
0
votes
0answers
31 views

SharePoint 2013 online List export to excel with views as worksheets

I have a client that would like to export a SharePoint List to Excel but to also include the views as the worksheets. How would I go about implementing this? Is this even possible? The data would ...
0
votes
0answers
76 views

Error when trying to reference an excel sheet inside SharePoint document library “The file name, directory name or volume label syntax is incorrect”

I have the following :- SharePoint document library. Inside the document library i have; Visio diagrams + excel sheet. now i am using an Add-in inside the Visio drawings to reference the Excel sheet ...
0
votes
1answer
10 views

Convert Sharepoint webpart 2013 to 32 bit version

Are there any ways to convert the visual webpart to 32 bit version. I have target in the property project c#, but I couldn't add the webpart to page. What I meant is in my case: I open excel file by ...
0
votes
1answer
279 views

Excel Linked Cells

I have the following use case: Two Excel documents are stored in the same folder on a shared drive (a typical SMB Share). The workbooks are linked through a single linked cell. If you open both ...
0
votes
1answer
343 views

Open a link of Excel with the dialog popup window in quick launch SharePoint 2010

I have a Excel document in the Library SharePoint 2010. And I set "Open in the client application" in Library setting. Every time I open this document, there is a popup window with a question "How ...
0
votes
0answers
13 views

Excel Services Problem

one of our client was adding Excel access webpart to his site and when he clicked on Edit webpart properties, he is not able to see all the properties of Excel access webpart which he should see. When ...
0
votes
0answers
87 views

“Open In Excel” button inside the Xlviewer.aspx page return Error and I can not open excel using local office

Inside the xlviewer.aspx page of sharepoint 2013 when I click on "Open In Excel" at first I receive this Error: Some files contain viruses that can be harmful to your computer. it is important to be ...
0
votes
0answers
34 views

Give Permissions to the Excel WebPart

I created a new webpart page with ExcelWebRenderer. I want to give edit permission to a group for the excel page. Other persons have read only permission for this excel page. I created a group and I ...
0
votes
0answers
12 views

Copying part of Excel workbook to a different workbook in SharePoint 2010

I have a rather simple task, at least by the description. Let’s say I have a File A (xslb) on SharePoint A and I need to copy out some data from File A to File B. File B is xslx document on a ...
0
votes
0answers
29 views

How to export SharePoint 2007 AD Accounts to Excel

Is there any way to export SharePoint 2007 AD accounts to Excel? I know that there are couple of ways to export SharePoint Userinfo list to Excel. But i want to export SharePoint 2007 Active Directory ...
0
votes
1answer
22 views

Display a Excel Chart

I'm using sharepoint for my team, and i would like to dispalay charts which update daily from my data connections. Currently i use a images and update daily, i want to automate this by hosing the ...
0
votes
1answer
889 views

Getting fully qualified FieldUserValue instead of actual user name from SharePoint

I'm working on my first C# program, and it's a pretty simple program that uses a view of a SharePoint page to go through and delete things that are older than 5 days on that page. Before deleting the ...
0
votes
1answer
88 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
0answers
32 views

when user chooses Edit in Excel the spreadsheet just hangs trying to open

A user has complained that when they try to open an Excel spreadsheet on SharePoint by choosing 'Edit Workbook' then 'Edit in Excel' it tries to open but just hangs. This happens for any Excel ...
0
votes
0answers
72 views

Export data from excel to sharepoint list through a form

Is it possible to export data to sharepoint list from excel using vba macros. The list is populated through a form which has combination of check boxes, drop downs and text boxes and you have to press ...
0
votes
0answers
47 views

SharePoint 2013 - Excel SUMIF between to Excel files

In our system are since two weeks some Excel files where a connection between the files was made with the "SUMIF" function. the problem is that the user wants to update the data in the 2nd file (which ...
0
votes
0answers
83 views

Open html exported from Excel as a webpage

I've been troubleshooting this one for a while now. SharePoint 2013 is opening my htm/html files that I export from Excel as an Excel Worksheet. I want the htm/html files to just open as a html ...
0
votes
0answers
170 views

Sync Excel and SharePoint List

Has anyone ever done this successfully using Excel 2010 ? I downloaded the Add-in (SynchronizeWSSandExcel: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=9345 ) but it's ...
0
votes
0answers
26 views

how to stop DATEDIF function when employee is terminated

I'm using the DATEDIF function to Calculate the time an employee has been employed. I'm using =DATEDIF(G25,TODAY(),"y") But what I want to do is to stop calculating the time when an employee is ...
0
votes
0answers
15 views

refreshing a query in Excel from a list of Sharepoint

When I have added more records to a list on SharePoint and I run "refresh query" in Excel, I don't see the added records in Excel. Looking at the table the range of it can not be extended, for the ...
0
votes
0answers
149 views

excel macro to vlookup sharepoint list

I am trying to create a macro that looks up data (vlookup) from a SharePoint list. Once done, I want all the contents in my excel file to replace those in the SharePoint list. I can do all this from ...
0
votes
0answers
93 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
0
votes
0answers
12 views

Disabling copy/past in Excel Web App

Is there a way to prevent a user copying and pasting cells from online version of excel - either excel web services or web app?
0
votes
0answers
136 views

How to insert new records on an sharepoint list from EXCEL VBA

I have an worksheet with the code below and I wanna populate a SharePoint list with it, but the code returns me the error: It isn't possible update the changes while there is validation errors in ...
0
votes
1answer
27 views

Can I extract a list with a button in infopath 2010?

I'm working on sharepoint 2010. I want to know if it's possible to create a button which extract the list the infopath is based on in an excel sheet. Thanks.
0
votes
0answers
50 views

Opening older Office files in SharePoint 2013

We have an external SharePoint site set up using version 2013. We have saved Word documents and Excel spreadsheets in older formats such as Office 2003. The reason for this is that customers ...
0
votes
1answer
294 views

Unable to update an excel file in SP

One of our users is currently trying to update an excel file that is saved directly to our SP document library. Whenever he tries to update it and save it the changes for some reason never save. It ...
0
votes
0answers
27 views

how to change the headers of a list exported to excel?

I want to use the sharepoint 2013 feature exporting to excel from a list but I want to change the name of the fields, how can it be done?
0
votes
0answers
120 views

Insert SharePoint metadata into excel cell

What is the best way to create a system that inserts metadata fields of the document in SharePoint in a cell in Excel? I've done this behaviour multiple times in a Word document using the 'Quick ...
0
votes
1answer
152 views

Quick edit List URL field

I need to use the quick edit on a Link List (I am copying data from an Excel file). I am having trouble with the URL field, I can easly insert the URL but I don not know how to insert the URL name. ...
0
votes
1answer
41 views

How can I know what was modified in an Excel file hosted on a SharePoint site?

Currently, I have an alert set up so that if someone modifies an Excel file I receive an e-mail. It works fine. However, I can I tell what was modified when I go back to check on the file?
0
votes
1answer
256 views

Exporting discussion board with all the replies

Is there any way to export a discussion board to Excel with all the replies? I've tried clicking on Export to Excel from the ribbon, but what I get isn't what I want as this does not give me the ...
0
votes
1answer
99 views

Excel file which have macro enable not opening in IE

I've a requirement in which an excel file( Macro Enabled) is stored in SharePoint 2010 and when user clicks the file, it should open in the IE as read only file. The Excel file is opening in the IE ...
0
votes
0answers
86 views

Sharepoint list 2010 connecting to excel refresh data

I've managed to export all the files to Excel and upload it to Sharepoint location. This Excel file is used as table of content of all documents that we have in our company. I've also managed to set ...
0
votes
0answers
14 views

Excel slicers change height on Sharepoint

I've got a report that I publish on a Sharepoint site. When it's on my machine the slicer "size" "height" is set to 1.52". Once I load it to the Sharepoit site and someone opens it and edits it in ...
0
votes
0answers
31 views

HTML tag rotation only rotates dimensions but not text within

I saved an Excel sheet as an HTML file and I needed the header text to rotate 270 degrees. I made it work on all browsers while I edited and tested only as an independent HTML file, but when I added ...
0
votes
0answers
63 views

Excel web part not working in Chrome when navigating back to page

I have a page that is using Excel web parts that has links to documents that they can view. When they navigate back from the document the excel web parts aren't loading. This is only happening in ...
0
votes
0answers
21 views

Get the email of logged in user in Excel on SharePoint?

Get the email of logged in user in Excel on SharePoint? Since VBA doesn't run in O365 does anyone know a way to get email? I am trying to do reporting based off of email so a user only sees data in ...
0
votes
1answer
19 views

Caluclated Field/Formula: Automated Month Counter

I have a "Start Date" field and a "Months in Process" field. Upon changing the start date, I need the "Months in Process" field to start ticking from 0 and increase in increments of 1 month. Everytime ...
0
votes
1answer
2k 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, ...
0
votes
1answer
369 views

Excel document opening in web view even though default is to open in program

I have a document library with one Excel spreadsheet in it. The document library's settings are such that the spreadsheet should be opening in each client's Excel program, not in Excel Web View. I ...
0
votes
2answers
1k views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
0
votes
1answer
79 views

Generate ppt slides from Sharepoint data

There is a form in SharePoint and I need to generate an one page Powerpoint slide using some data from that Sharepoint list. I'm thinking about creating a template in Powerpoint. Let's say there will ...
0
votes
1answer
123 views

Is permission level affecting Excel links from updating?

I have some Excel documents on a Sharepoint site. I added some links to other Excel documents on a network drive. When I open the Excel files on the Sharepoint directory, they update just fine. ...
0
votes
2answers
7k views

Exporting SharePoint Members into Excel

Is there a proper way to export a group of sp group members into excel? I have been able to select a group from permissions and export them into excel. The problem I face was that even when I ...
0
votes
1answer
55 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
1answer
117 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
1answer
100 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
0
votes
0answers
22 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...