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

learn more… | top users | synonyms

6
votes
0answers
190 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
3
votes
0answers
143 views

Cannot Open Excel sheet in web-browser

I am having a problem opening the excel sheet in web browser, it throws an exception.. Excel Web Access >> An error has occurred. Please contact your system administrator if this problem ...
3
votes
0answers
4k 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
66 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
0answers
204 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
2
votes
0answers
70 views

Writing excel 2003 vba to extract a Sharepoint list to Excel

I'm trying to find some Excel 2003 VBA that will let me inport a sharepoint list into Excel so that I can perform some basic tasks on that data.
2
votes
0answers
289 views

How to make a List Column link to Excel Cell

I have a SP library that lists the names of various excel spreadsheets. Each spreadsheet has a cell that reflects the percentage of completion for a project. I also have a SP list of projects, which ...
2
votes
0answers
549 views

offline and online (SP 2010) version of Excel with slicer

An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend. The browser gives following error. "The workbook cannot be opened ...
1
vote
0answers
13 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
10 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
0answers
10 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
32 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
0answers
52 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
0answers
67 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 ...
1
vote
0answers
55 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 ...
1
vote
0answers
201 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
109 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 ...
1
vote
0answers
37 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
0answers
61 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: ...
1
vote
0answers
384 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
0answers
28 views

Sharepoint Online 365 and refreshing excel files

Is there a way to have the excel files refresh their links hourly or daily?
1
vote
0answers
48 views

code for redirecting to a page from a link in excel

I have an application where all my list data is getting exproted to excel. In excel there is a link in a column. On clicking that link it should redirect to a page form excel. Require c# code for that ...
1
vote
0answers
24 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
0answers
181 views

How to apply “Table Style Medium 4” template formatting to excel created using open xml?

Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation ...
1
vote
0answers
27 views

Having issues looking at all old versions

I've been trying to look at older versions of a file but keep getting this error? Any idea what it's happening? I've looked at the source of the document within Excel and it's looking for a copy ...
1
vote
0answers
399 views

Cannot Save Excel to Sharepoint

One of my users is having an issue saving to Sharepoint with some very specific parameters. the problem is related to saving only from within excel if a document has been opened from SP. She is ...
1
vote
0answers
47 views

Sharepoint 2010 issue with exporting certain combination of columns from a view

so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...
1
vote
0answers
273 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
281 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
24 views

How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service

We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...
1
vote
0answers
204 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
1
vote
0answers
29 views

Import excel spreadsheet with photos

I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos. What am I doing wrong?
1
vote
0answers
58 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
1
vote
0answers
2k views

Unable to check-out an excel sheet from a document library in SharePoint 2010 Standard

I have a document library under my SharePoint 2010 Standard site. We are uploading Excel files to this document library to be updated by multiple users (Using Check-in/Check-out). We are using IE9 as ...
1
vote
0answers
319 views

SharePoint 2007 WebPart Event Handling on Custom ASPX webpart page

What I'm trying to do: I've got a custom aspx page that is wrapped in a SharePoint feature in order to get deployed. This aspx page contains 4 (Excel Web Access) web parts that are added dynamically ...
1
vote
0answers
89 views

Need to be able to select on a column that can have one ore more values

I have a column in a sharepoint list that lists the various departments within my company. One or more of these departments can be selected. Since the column does not show up as a selection when I ...
1
vote
0answers
138 views

Excel -> SP List with correct column types?

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...
1
vote
0answers
523 views

Exporting Custom List view in Sharepoint 2010 to Excel

I am creating a custom list view programatically which hides some of the columns in the actual list. But while exporting to excel all the columns are visible. Any tips/help is appreciated.
1
vote
0answers
257 views

Want to link to specific sheet in Excel workbook which is stored in SP10 doc library, but usual method not working

I have an excel workbook stored in Sharepoint 2010 document library. It contains several named sheets. I wwant to link to the workbook from a Wiki or List but I want specific sheets to be visible ...
0
votes
0answers
9 views

Can not open an Excel document from SharePoint

My problem occurs only for Excel files from a SharePoint 2003 WSS2. I meet the problem with all versions of Internet Explorer Details of the problem: When clicking on the Excel file (screen 1) a ...
0
votes
0answers
9 views

Export DVWP to formatted Excel spreadsheet

I've got a page on my SharePoint 2013 site that shows a report. The report itself is a DVWP, but I need the ability to export the report into a pre-formatted spreadsheet. I can currently right-click ...
0
votes
0answers
16 views

Reading/Writing to excel

I have a requirement to read/write to excel. I am aware that it can be achieved by using Sandbox solution or provider hosted app. I am trying to do this via jquery. I came across this site which looks ...
0
votes
0answers
17 views

Excel preview in EditForm or DispForm - plug-in not supported

I have been troubleshooting this problem for a while now. When I open list item (that is excel or word file), then I will see empty area in IE and gray area in Chrome and Firefox, that give me ...
0
votes
0answers
21 views

Export to excel - Refresh every n minutes in excel greyed out

I exported sharepoint 2010 list to Excel 2010 and saved in a network location. I want to refresh the excel automatically for every 2 minutes. But the option "Refresh Every ... minutes" is greyed out ...
0
votes
0answers
4 views

Embed data sheet view of a list on a application page

I have a requirement where I need to show a data sheet view on a application page. Basically I have replaced the newform.aspx with a application page. This application page displays data from another ...
0
votes
0answers
24 views

Office 365 for Mac(Yosemite) SharePoint won't open file in Excel.

File xlsx uploaded to SharePoint won't open using the Edit in Excel button. It appears to start, but not finish. Excel does not include this file in 'recent files', so cannot be opened from Excel. ...
0
votes
0answers
31 views

Excel 2013 Not Saving To SharePoint 2010 Library

I've got a peculiar problem with a couple of users having issues saving back their Excel document to their Document Library. As it is now, they'll have issues when they open the document from ...
0
votes
0answers
31 views

Auto refresh Odata connection between SharePoint list and MS Excel

I have an Odata connection set up in Excel Services to SharePoint list data. The Odata connection pivots the list data, then charts it in Excel Services, and the chart is hosted in SharePoint When I ...
0
votes
0answers
14 views

Problem with Excel View and Calculated Column

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...
0
votes
0answers
16 views

Export to Excel does not export columns with multiple selections in SharePoint 2013

I am trying to export a list to Excel (Office 2013) that contains columns containing multiple selections, except the columns with multiple selections are completely missing from the exported Excel. To ...