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

learn more… | top users | synonyms

3
votes
3answers
10k views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
0
votes
1answer
31 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, ...
1
vote
2answers
268 views

Excel services refresh using Claims based NTLM?

I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...
0
votes
1answer
187 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
20 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
564 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
2answers
6k views

Sharepoint 2013 pasting text into a cell of multiple lines type

I am trying to copy & paste a cell of data from excel to my sharepoint list. The excel cell of data consists of multiple lines of text, so when I copy & paste in the data it pastes it onto ...
0
votes
0answers
67 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
274 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
37 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
34 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
31 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 ...
2
votes
2answers
39 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
88 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 (...
0
votes
1answer
659 views

Sharepoint 2010 / Google Chrome / Excel

From one of our users: Now that many of the items seem to work with Sharepoint and Chrome, one of the biggest outstanding issues is that it wants to open the documents in the browser by default. ...
1
vote
0answers
485 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
81 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
153 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
75 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 ...
1
vote
0answers
101 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
110 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 ...
1
vote
1answer
307 views

Sharepoint Excel data table and Chart

Need help about sharepoint. I have a table data collection currently in ms excel document look like the following image. every last day of the week the information will be updated (append new file)...
0
votes
1answer
2k views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
0
votes
2answers
292 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 ...
1
vote
3answers
1k 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
10k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
1answer
67 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
1answer
804 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
111 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 ...
8
votes
2answers
9k views

Adding document version number on Excel Spreadsheet as label for printing purpose

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document. I ...
0
votes
0answers
35 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?
3
votes
0answers
6k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
2
votes
0answers
485 views

“Open in Excel” prompt disabled when accessing workbook through office web apps

We're trying to share an excel workbook through SharePoint which sends a link through mail with "web=1" which calls for excel web access. since the document has unsupported features in OWA, it prompts ...
1
vote
0answers
223 views

Unsupported features: Display of formulas in cells

I have a number of Excel templates that are stored in SharePoint library. When trying to either view or edit the files in my browser, I get the error message that the browser can't be used because ...
0
votes
1answer
327 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
659 views

How to get excel file from sharepoint library and write to it programmatically

we would like to read an Excel template stored in a SharePoint 2010 library create a new Excel file from it fill the new Excel file with data programmatically we tried already Excel Services but ...
2
votes
6answers
16k views

Importing an Excel file to a list - how to control the column types

I am attempting to import an Excel file into SharePoint using Create List > Import Spreadsheet. Several columns are just short text fields < 100 chars and with no formatting/line breaks etc. Some ...
0
votes
1answer
47 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?
3
votes
1answer
113 views

How can I see what has changed in an excel file that is posted on SharePoint?

I currently have an Excel file posted on SharePoint 2007 with an alert set up to tell me when it is modified. It works fine, but my question is how can I tell what has changed when I go to review it?
1
vote
0answers
73 views

Is it possible to filter chart without refresh?

I have created a chart in excel using PowerPivot and I am using oData Data Feed to get values from my SharePoint List. I have set auto refresh at every 60 minutes and I have used some filters also. I ...
1
vote
1answer
2k views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
1
vote
0answers
266 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...
1
vote
1answer
206 views

Sharepoint List & Export to excel sheet

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ? If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and ...
3
votes
1answer
35 views

Reusable Tasks - moving an process from excel workbooks to SharePoint

My team use a SharePoint 2013 team site. Currently when we deliver training we use an excel workbook which tracks student names, and tracks their scores and has a standard task list of content that ...
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 ...
2
votes
0answers
148 views

Excel and PowerPoint to talk via SharePoint Libraries

We are looking into a way for an Excel file and PowerPoint file to exchange data. I'm thinking Excel Web Services, OpenXML, SharePoint Office Apps and/or maybe CSOM. Requirement is coming up to: ...
4
votes
2answers
4k views

Run an Excel Macros from SharePoint

I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
0
votes
1answer
625 views

Linking an Excel document to a List

I have an excel document which is sent daily to me. I have a SharePoint List that is then update daily by me with all the excel documents information (complete overwrite each day). The list is used ...
2
votes
1answer
292 views

Excel web app Sharepoint Online

I am currently implementing some Powerview in excel that is used on sharepoint online. My problem is that I can't get excel web app to save automatically when something is changed in excel web app ...
1
vote
0answers
222 views

Export to Excel is slow

I am working with SharePoint 2010 / 2013. Very often I have to export large lists (>1000 Items) to Excel. This always takes some time (e.g. about 3 Minutes for 3500 list items). Is this normal, or ...