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

learn more… | top users | synonyms

0
votes
1answer
20 views

Excel Files in SharePoint Designer

I added excel file (.xlsx) in SharePoint Designer. These files appear as notepad in SharePoint Designer. I want to these files appear as excel file. How can I do this?
0
votes
0answers
14 views

Refresh data in online PowerPivot Excel sheet?

I have a Excel sheet that loads the data from a SharePoint list. If I do the following I get below error: Make a pivot table to display data. Save and upload the sheet. Now to Refresh the data to ...
0
votes
1answer
96 views

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost

I have a SharePoint document library. On exporting to excel I get an error message the table contains a string that is too long for excel to display. if you edit the long value some data might ...
0
votes
1answer
1k 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
0answers
15 views

Linked Excel to Access and then to Sharepoint

I don't know if it's possible, but I'm asking the question anyway. I have a "master" Excel file where the data is located. The "main" interface is quite complex. Basically, it's a calendar to keep ...
0
votes
1answer
14 views

How to add the Excel file in the page on the Sharepoint 2010 foundation?

I would like to insert an excel file into the Sharepoint page on SP 2010 foundation. I saw we can export list to excel, so that I think maybe we can display the excel file in the page. In SP 2010 ...
0
votes
0answers
14 views

Subscription on Excel files in SP 2013?

I administrate a SharePoint 2013 site which is mainly for business reports (.rdl files). Standard SSRS (reporting services) allows you to create subscriptions for these files, but I would like to be ...
0
votes
0answers
23 views

Append Excel data in Sharepoint list

I would need to append data from an Excel template to a SharePoint List. I explain better. Every day employees will open excel template, they will fill in the data and then I will need to append all ...
1
vote
0answers
16 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 ...
0
votes
1answer
28 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
0
votes
3answers
435 views

Files downloading instead of opening in Chrome

User is accessing SP through Chrome (rest of us have IE). When they click on a spreadsheet they don't get the usual prompt to select read only/edit mode. The spreadsheet opens and they make their ...
0
votes
0answers
12 views

“Continue Interacting?” Prompt

We are hosting excel files in sharepoint (with an Office Web Apps server) The users get the below message if they don't interact with the excel file after a few minutes. Is there a way to increase ...
0
votes
0answers
90 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
1
vote
0answers
48 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) ...
0
votes
0answers
29 views

Using mail merge with word 2013 to get data out of excel 2013

We want to use mail merge in a word document which is saved in a sharepoint 2013 document library. If we try to connect to an excel sheet which is also located in the same document library, we get the ...
0
votes
2answers
74 views

how to export the data from a webpart to excel and pdf in sharepoint 2010

I have a custom Web Part which retrieve the data from SQL Server 2008 manipulates it and shows the data table in UI. Below is the UI of the data on the Web Part. The data contains URLs, Dates, Names ...
0
votes
1answer
20 views

Surveys with Export to Excel option

How do I ensure that once I create a survey in SP 2010 that I'm able to export the resposes to Excel?
0
votes
1answer
68 views

Connect SharePoint Lists with OData

I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list ...
0
votes
0answers
12 views

Formatting issues when uploading excel tables

I am uploading an excel table with 4 columns to a sharepoint list. The first three columns are text, and the last column numbers. When I go to upload, it says that the middle two columns will be ...
0
votes
1answer
55 views

How to handle Excel sheets with macros

We have an Excel sheet with Macros on it. We uploaded the Excel sheet into SharePoint Document Library. When the Excel is opened using Excel Online, Macros do not work. So in order to make Macros work ...
1
vote
1answer
255 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
1answer
80 views

Force a document to open in the application and not the web app?

I have a large Excel file (under 1 meg, but almost 25 tabs) that none of my users can open in Excel Online. If you click on it in the document library, it spins for a while before giving this error: ...
0
votes
0answers
16 views

Checking In Edit in Excel document not updating quickly

A user was reporting that when they were editing and checking in files, they weren't showing up. I created a file in this library and this is what I found: Check Out Edit in Microsoft Excel Add ...
0
votes
0answers
45 views

PowerView Export to PowerPoint Functionality in Office 365

I am looking to be able to export a PowerView document to PowerPoint but cannot seem to find that functionality in the latest release. I am using Excel 2013, latest updates, and a SharePoint Online ...
0
votes
0answers
29 views

HTTP request on lists.asmx GetVersionCollection method

While looking for a HTTP REST method to return Document Version History, I stumbled on the GetVersionCollection method. However, I have not found any syntax showing how to make the call from a ...
4
votes
1answer
642 views

Saving an Excel file: You do not have the correct permissions. Contact the server administrator

A user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
0
votes
1answer
282 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
83 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
22 views

How to add SSAS excel report on SharePoint page?

We have a Excel Sheet which has got a Chart that is generated from an Analysis DB (Excel connects to Analysis DB with a particular credential which is setup when connecting to Analysis DB via Excel). ...
0
votes
1answer
23 views

How many webparts are available in SharePoint for displaying an excel sheet/excel report?

We are doing some R&D on displaying excel sheets (simple sheets with no external data connection) and excel reports(which connect to sql db) on a SharePoint page. I would like to know what are ...
1
vote
0answers
22 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 ...
0
votes
0answers
21 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 ...
1
vote
0answers
25 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 ...
4
votes
3answers
4k views

Filtered SharePoint List for Export to Excel

I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then ...
2
votes
4answers
13k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
9
votes
9answers
39k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
3
votes
2answers
51 views

Can you have multiple Excel worksheets for one SharePoint List?

I know you can create a table in Excel and export that into SharePoint as a list. I want to know if you are capable of having two or more Excel files updating a single SharePoint list. We want two ...
0
votes
1answer
6k views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
2
votes
1answer
137 views

Publish and Synchronize Excel 2013 as Sharepoint List

Can we publish and synchronize excel 2013 table as SharePoint list. I understand that using export to excel functionality and using data connection changes in the list gets reflected in the excel. But ...
3
votes
0answers
153 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 ...
6
votes
2answers
309 views

Excel files always open in browser

On our Intranet I have activated the site collection feature "Open Documents in Client Applications by Default". On the Document libraries I have also set the *Default open behavior for ...
0
votes
0answers
19 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 ...
5
votes
1answer
177 views

Can someone help me use SharePoint 2010 to do data processing?

TL;DR: I need to create a system in SharePoint in which a user uploads an Excel (or CSV) file to the site from a webpage. The site takes the uploaded document and uses it to populate a list. Then it ...
1
vote
1answer
110 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 ...
8
votes
7answers
37k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
0
votes
1answer
59 views

Extract infopath xml data into excel

I have around 2000 InfoPath forms in SharePoint 2010 document library. I want to extract all forms in excel using macro. Any help?
0
votes
0answers
29 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 ...
1
vote
0answers
19 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 ...
0
votes
0answers
23 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 ...
1
vote
4answers
10k views

Export to excel - large lists

I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...