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

learn more… | top users | synonyms

0
votes
0answers
5 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 ...
1
vote
1answer
19 views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
0
votes
0answers
9 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 ...
1
vote
2answers
31 views

Link on wiki page to Excel document that opens in Excel Online

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online. When I create the link using Insert -> Link ...
0
votes
0answers
34 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
16 views

Alternative ways to read excel in Sharepoint

Now I'm facing with a problem of reading excel file on SharePoint server. In the old ways I usually use the OLEDB to read excel through the connection string, but it's just work on 32 bit system, ...
0
votes
1answer
27 views

SharePoint Exports to Excel, can't I get directly in .xlsx file?

I am using SP 2013 foundation. I am able to export list into .iqy file. Which is good. But users wants directly .xlsx or .xls files. Is it possible to do that?
0
votes
1answer
6 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
25 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
38 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 ...
1
vote
1answer
7 views

Can find (Excel services application & Visio graphics service ) inside the Service application menu

I have installed a new SharePoint server , and I wanted to create a new Visio graphics service and Excel service application, so that users can view excel & Visio documents inside their web ...
0
votes
0answers
6 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
26 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
17 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
1answer
30 views

How do I have a workflow update a field/column in the current list(InfoPath created list)?

I have a column with this formula: =YEAR(Created)&"-"&(ID) , the YEAR(created) part works as intended but the ID part doesnt. It often shows only 2014- but it should show 2014-50, the 50 beign ...
0
votes
0answers
8 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
16 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 ...
1
vote
1answer
36 views

Using firefox to edit office documents inside my document library

I have a problem in understanding what is the standard approach to follow for editing office documents inside my document library. As it seems each browser will have different behavior when it comes ...
0
votes
1answer
14 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
71 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
23 views

column formula help

I've asked a question a couple days ago, wich gave me the answer =IF( OR(INT(A)+INT(B)+INT(C) = 3, INT(A)+INT(B)+INT(C) = 0), "Accepted", "Not Accepted" ) But that only works if they have to fill ...
0
votes
2answers
46 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...
2
votes
2answers
32 views

Sharepoint formula limit help

i've been making this formula(based on previous questions) which works great(with 3 id's), But when i try it with all my id's it give me an error "Cannot complete this action". Can anyone help me out? ...
2
votes
1answer
56 views

help Column formula in sharepoint list

So i asked this question a couple hours ago: I have made a list with InfoPath in SharePoint. All the questions are either "accepted" or "notaccepted" (radiobuttons) and I want to make a new column ...
1
vote
0answers
17 views

Connectivity issue from Excel 2010 to SharePoint

We are using Excel 2010 and was running in Window XP. Connectivity with SharePoint was good. Recently our environment got migrated from XP to Windows 7. Until that point we are seeing the following ...
1
vote
1answer
30 views

Registration Form To Populate Excel Sheet

I'm trying to add a web registration form for people to sign up for a lunch and learn. The idea would be once a user presses submit, his/her info would automatically post to the Excel sheet and the ...
0
votes
1answer
33 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
7 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
32 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
19 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 ...
1
vote
1answer
62 views

create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013?

I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content ...
0
votes
0answers
27 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
62 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 ...
1
vote
0answers
55 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
0
votes
0answers
12 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
26 views

Sharepoint Excel Error IE9 - Workbook is larger than the maximum workbook size allowed to be opened in the browser

A few of my users who are using ie9 for a sharepoint housing a few excel files around 19mb are experiencing a recent issue where they cannot see 'read only or edit' options; (this is enabled to open ...
0
votes
0answers
11 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
67 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
59 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
11 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
3answers
77 views

Export selected item from list to excel

I'd like to know if there are a way to export to excel the selected items in a sharepoint list i'm in sharepoint 2010
0
votes
1answer
110 views

Automatically Import Excel Data to SharePoint List

This question has been asked before but I haven't found an answer that works for me and my limitations. I have an excel spreadsheet that is currently being used to input data with 20+ records each ...
0
votes
0answers
59 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
22 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
22 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
63 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
1answer
49 views

Updating excel information to a list matching a custom ID column

I'm on SharePoint 2010. An excel file is uploaded to a document library.This excel file has a custom ID column(alphanumeric) and many more columns. There is a list which contains many columns along ...
0
votes
2answers
106 views

Error when I fill in metadata in excelsheet Document Information Panel

I am using sharepoint 2010. I have a document library with a contenttype. I have some word, excel and pdf documents inside of it. When I open an existing excel sheet and go to the Document Information ...
0
votes
0answers
20 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?
1
vote
0answers
34 views

Use a workflow to filter a list

I have a spreadsheet that contains numerous products, each one with a unique PN, desc and price. There is similarity between products, contained in additional columns with simple YES or NO values ...