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

learn more… | top users | synonyms

1
vote
1answer
316 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 ...
0
votes
1answer
313 views

How to create editable table in Sharepoint

I want to use Sharepoint to host a table that multiple people can edit (like an online spreadsheet, for example). I have tried various things which have not worked: I tried downloading a plugin for ...
0
votes
0answers
40 views

What else is in the _layouts folder?

I found a useful way to force an InfoPath form to open directly in the InfoPath client (even across different SharePoint domains) by using the FormServer.aspx page within the _layouts folder. I do ...
0
votes
0answers
21 views

User can't refresh data in Sharepoint List after SQL View Def changed

I am trying to support a user who uses a SharePoint 'report' (ie Excel SS). The report is based on an SQL Server 2008 View. The view definition was altered to source data from different tables within ...
0
votes
1answer
17 views

How to syncronize an Excel document in SharePoint with Access

I have an Excel Sheet stored in a SharePoint list, but this list will be updated every month. So some employees get the Access file and need to fill in their values, but they should just open the ...
0
votes
2answers
196 views

How export list in excel file

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error: Error List does not exist. The page you selected contains a list that does ...
0
votes
0answers
89 views

Export list to excel issues with data type number

so I have a two lists that are connected using lookup, when i export the list to excel the number column (its a lookup column) shows as 10.000000 instead of just 10.. I have tried formatting the cells ...
0
votes
0answers
17 views

Office documents stalled in loading state form expansion list

After opening and closing excel files shown on the right picture they disappear and all I see is Loading shown on the left picture. It stalls there and it will not load anything. The only way for me ...
1
vote
1answer
320 views

Data Connection does not refresh in Excel

I have a SharePoint list; Exported into Excel file and set the property to refresh Data Connection every time the file is opened. It worked very well in Excel installed on my system but when I ...
0
votes
0answers
21 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
29 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
1answer
494 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
0answers
53 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
27 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
39 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
69 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
25 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
48 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
1answer
243 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 ...
2
votes
1answer
316 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
71 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
1answer
32 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
2answers
568 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
1answer
201 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 ...
0
votes
2answers
682 views

Mail Merge with Excel Document stored in SharePoint

We have an Excel Document we would like to use as a source file for a Mail Merge in Word. When we open the Excel file in the mail merge wizard we receive the following error. "Sorry we couldn't ...
0
votes
2answers
506 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
491 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
1answer
28 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
26 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
33 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
3answers
4k 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 ...
1
vote
0answers
66 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 ...
3
votes
2answers
466 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 ...
2
votes
1answer
5k 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
2answers
335 views

SharePoint - Embedding Excel using Excel services

We are trying to embed Excel using SharePoint Excel Services and we are getting the following error, We're sorry. We ran into problem completing your request. Please try again in few minutes ...
7
votes
2answers
2k 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 browser-...
1
vote
1answer
685 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
0answers
43 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
1answer
182 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?
1
vote
1answer
32 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
153 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
25 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 ...
0
votes
1answer
260 views

How to export to excel only items filtered on my view

In my specific list, I filtered to a account we are going to pay. Then when I click on "Export to Excel" button all the items of the list gets exported. How would I export data that I want? Example:...
0
votes
0answers
134 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
1answer
54 views

Can I apply check out rules to a single document in a document library and not the whole library?

Is it possible to apply check in/out rules to a single document in a document library without applying the same rules across the document library via the Library "Version Settings" section?
0
votes
2answers
28 views

Connection to SharePoint list on SP 2010/13 STANDARD Edition

My organisation will downgrade from SharePoint 2010 Enterprise Edition to SharePoint 2013 Standard edition. I am not part of the decision making, but I heard the decision relates to cost or licensing. ...
3
votes
1answer
1k views

Can I edit a workbook using Excel Services?

I created a web part putting my Excel worksheet on one of my Document Library, so I can have the live view of that worksheet without opening it again and again, my question is, can I edit that ...
1
vote
2answers
2k views

Creating Excel document using JavaScript

I've been researching into creating Excel documents in a SharePoint Library from an existing Excel template but all solutions I find are using server code. The Template can be part of a CT or in ...
0
votes
0answers
425 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 ...
1
vote
0answers
155 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 ...