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

learn more… | top users | synonyms

1
vote
1answer
72 views

How to access Excel cells hosted on Sharepoint (Office 365) using Java client?

I host my site in asphostportal and I am trying to build a Java clinet that connects to Sharepoint (mysite.sharepoint.com) and grabs an excel file. I used the Excel services WSDL file, however the ...
1
vote
2answers
119 views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
1
vote
1answer
58 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 ...
1
vote
3answers
400 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
1
vote
1answer
115 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 ...
1
vote
1answer
2k views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
1
vote
1answer
126 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
1
vote
1answer
763 views

Excel document not updating on open

I have an excel document that is linked to a SP 2010 list. I set the connection and the update on open. It works just fine (i.e. updates with new data) when the file is on my local machine. However ...
1
vote
1answer
837 views

How to import excel spreadsheet to SharePoint document library?

Excel spreadsheet has several columns including a filename column which has actual path to file, that file should is exactly I want to be imported to document library. Once imported the filename ...
1
vote
1answer
56 views

Windows 7, excel and word 2010 how get RID of Sharepoint popup window? [closed]

When using Excel (and possibly Word) this irritating popup window appears requesting some kind of password. I want to get RID of this window and get rid of Sharpoint, whatever it is.
1
vote
2answers
224 views

Merging excel documents similar to slide libraries

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...
1
vote
1answer
1k views

Generating Excel Export using a link?

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can ...
1
vote
2answers
137 views

Sharing a Spread Sheet on SharePoint and making sure Data changes reflect in document

I have a spread sheet to which i make changes weekly. There are different kinds of data in the spread sheet. I want to make different parts of data visible to different people in my team on the ...
1
vote
1answer
635 views

IF AND CONCATENATE Nested Statement in Calculated Column SharePoint 2010

I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files ...
1
vote
2answers
3k views

Fail to export custom SPList to Excel

Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
1
vote
1answer
6k views

Why are .xlsm files opened as read-only when .xlsx are not?

I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
1
vote
2answers
420 views

Import a single row from Excel spreadsheet

I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row! Is ...
1
vote
1answer
409 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
1
vote
1answer
2k views

Recovering data from modified infopath fields?

I had built and published an infopath form to a sharepoint library and populated the library with about 50 documents(based on the template) I modified (deletd rich text boxes and replaced it with ...
1
vote
3answers
4k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
1
vote
1answer
498 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
1
vote
2answers
243 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. ...
1
vote
1answer
183 views

Excel Services Using SQL Server 2008R2 Refresh

I have an excel file set up to pull data from SQL Server 2008R2. I can view it and refresh it fine locally in Excel 2010. I upload it to SharePoint 2010 and can view the data in the spreadsheet in ...
1
vote
1answer
216 views

Edit Document in Sharepoint

I have an issue when editing and save sharepoint Office document. Firstly if I am right clicking on the document and saving it. It is fast and fine. If I try to edit it in office, it opens very slow ...
1
vote
1answer
303 views

Office Web Apps Word - Configure trusted locations

It is possible to configure the trusted file locations for the Word Web App on SharePoint 2010? I only can find the settings to configure the supported file formats at the Word-Service Application ...
1
vote
1answer
902 views

How to add Excel web access web part in WSS 3.0

I'm new is SharePoint and struggling with adding web part. I'm using WSS 3.0. I want to add Excel Web Access Web Part, so I go to site Actions -> Web Part Gallery and try to upload .wdp file which ...
1
vote
1answer
600 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...
1
vote
2answers
274 views

Ability to migrate linked Excel spreadsheets to MOSS

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
1
vote
1answer
659 views

How to bulk update records in a SharePoint List with a lookup column (with type Person)

In SharePoint 2007 I have a List containing two columns: "Title" of type single line of text "Email" of type Person or Group Because I have to update a lot of records, I use export to Excel to ...
1
vote
1answer
2k views

sharepoint 2010 : Download Data as Excel reports

We are working on a share point 2010 application where there is a requirements of complex reporting. As per requirement there will be a Link List which will have couple of links. On clicking these ...
1
vote
1answer
3k views

Excel new document template opens in Notepad

I have a document library with a custom document template. The template is an .XLTX file that I created using Excel 2010. It is associated to the library via a custom content type. The template ...
1
vote
4answers
2k views

Can an Excel file be used as an external content type?

or an external datasource? Can that be set up in SP Designer 2010
1
vote
2answers
2k views

Can I export a SharePoint 2007 list to an Excel file subdivided into separate worksheets?

We have a SharePoint 2007 deployment which will have a substantially large document library. My client wants the ability to export this library to an Excel spreadsheet, but specifically wants the ...
1
vote
2answers
954 views

How do I make a easy print out (overview like excel) in Sharepoint?

If we use action items for projects/meetings and we want to make an easy print overview, this seems to be impossible. Any ideas or suggestions?
1
vote
2answers
39 views

can I import spreadsheets into sharepoint list without excel installed locally?

Is there a way to import a spreadsheet into SharePoint List if you don't have Excel installed locally? Can Office Web Apps or even Google drive sheets be used instead of excel? Edit: I have Excel ...
1
vote
0answers
14 views

sharepoint - accessing excel files from VBA

I'm trying to access SharePoint directory from Excel VBA and loop over all files at this directory. But when I try to refer to the directory, then I get this error in return: Path not found I ...
1
vote
0answers
10 views

Link Access to a SharePoint file whose name keeps changing

I have an Access database that I would like to link to an Excel file located on SharePoint. Normally, this is easy to accomplish as SharePoint/MS Office are well integrated. The problem is, the Excel ...
1
vote
0answers
29 views

Can't crawl Excel 2003 files from SharePoint 2013

I have a SharePoint 2013 farm and am crawling the contents of a legacy SharePoint 2007 farm on the same network domain. I am getting the following error crawling Excel 2003 files (i.e. xls format) ...
1
vote
0answers
21 views

Is it necessary to configure Excel service application and secure store to view excel reports in SharePoint?

We are using SharePoint 2013. Now we need to add some excel sheets and excel reports onto the SharePoint page. So we have seen that there is a Excel viewer webpart. I was wondering whether it is ...
1
vote
0answers
23 views

SharePoint Online: Problem opening Excel

SharePoint Online Excel 2010 Internet Explorer 11 I've recently completed a SharePoint 2007 to SharePoint Online upgrade and am dealing with a few user issues in the project's wake. One user in ...
1
vote
0answers
17 views

Users Cannot Open Document In folder to edit

I have a Site with a Document Library with a User with Full Control. We are running in https mode. The users cannot open the Spread Sheet for editing, though I can. The site is also asking her to log ...
1
vote
1answer
21 views

Automaticly update connected excel file when a new item is added to a sharepoint list

I have a sharepoint list that we update daily and it is connected to an excel file that we update manualy. So what I would like is when a new item is added to the list it automatically updates the ...
1
vote
1answer
57 views

Using SP.FileCreationInfo to modify an .xlsx or .xls file

I'm trying to create a client-side solution where customers can download a template .xlsx document populated with data filtered from a SharePoint list. I know that JavaScript generally isn't used to ...
1
vote
0answers
11 views

Workbook.CheckIn always produces an error the first time it's called? (x-posted on StackOverflow)

This question is cross-posted on SO here. I have some workbooks stored in a document library on Sharepoint 2007. I want to check out a workbook, modify it, and check it back in. Using the following ...
1
vote
0answers
52 views

Excel Connect to SharePoint Online Document Library

We have a number of people in the field who fill out fairly complex evaluation forms in excel. These forms are submitted to a document library in SharePoint Online What I need to be able to do is ...
1
vote
1answer
38 views

Excel Access Web Part changing my Top Navigation Bar

I am a newbie on this site. I am NOT a SharePoint developer or admin by trade. I have accumulated this job with on the job training. I am by far not an expert or claim to be. My issue is this, when I ...
1
vote
1answer
64 views

Sharepoint Excel Dynamic dashboard according to a list

I've a list which has something like this: List Title Status Title 1 Active Title 2 Pending Title 3 Active Title 4 Closed I need an Excel BI dashboard which should be dynamically ...
1
vote
0answers
66 views

VB script to automate importing sharepoint list data to excel

I need to automate pulling data from SharePoint list data to excel through writing a VB Script (not VBA). How can I import data directly from a SharePoint List into Excel using VB script? Currently, ...
1
vote
0answers
35 views

Open In Excel Issue

I have two sites on SharePoint2013. I used excel webpart. I worked these sites in IE 11. "Open In Excel" works a site, but doesn't work other site. What is the cause of this problem?
1
vote
1answer
85 views

Removing fields from document properties bar on Excel sheet linked to SharePoint library

I have an Excel sheet which is linked to a library in SharePoint, which has a 'Document Properties - Server' section at the top. They fill out the Excel sheet, save it to the library, and the ...