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

learn more… | top users | synonyms

2
votes
1answer
1k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
0
votes
0answers
10 views

Read excel file from sharepoint document library in office 365 programmatically

I have one excel file uploaded in document library of office 365 site.I want to read this excel file using c# as we read in farm solution using following code. using (SPSite site = new ...
1
vote
3answers
2k 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 ...
4
votes
2answers
2k 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
1answer
1k views

SharePoint Foundation [Unable to process the request in Excel Web App]

I am encountering below error msg whenever I try to open excel file (.xls, .xlsx) in SharePoint Foundation 2010 portal. Other Office files such as word, ppt opens correctly without any error but ...
0
votes
0answers
46 views

Content of Excel document is not updated

I recently faced a wierd glitch. When someone updates an Excel speadsheet that is on Sharepoint in Excel application on a computer and saves it, and then clicks on that same document in a browser to ...
1
vote
1answer
21 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
2answers
782 views

Export SharePoint Search Results and List View to Excel

Can we export SharePoint Search Result to Excel? Note that our client is using SharePoint Foundation 2010. I have searched the web and found a free tool that does this but unfortunately it works only ...
0
votes
1answer
18 views

Faster way of Downloading Metadata in CSV

we Have document library with 3lacs+ items. we have to download metadata of each file in a csv such as Modified date , modified By etc. I used powershell code for achieving this task but for some ...
0
votes
0answers
12 views

SharePoint 2013 - XLViewer

Is it possible to customize the XLViewer in SharePoint 2013 out of the box? By out of the box, you can find options in, say, Central Administration to modify the access rights such as allowing the ...
0
votes
0answers
10 views

My sharepoint opens a file into the client app as read-only, with no option to 'edit workbook' or save it

I have a sharepoint workbook with macros enabled and linked to an access db in a network folder. Now, when I open the file, it no longer gives me the edit workbood option and the top and prompts me ...
0
votes
0answers
7 views

Implement export Asp.Net chart from SharePoint to excel or PDF

I have requirement from client to export chart to excel and pdf. Charts are displaying as expected but when try to export the chart into Excel or PDF file chart image is blank. Please post some ...
0
votes
0answers
8 views

How can I link an Excel workbook to one in a restricted folder?

In our SharePoint there is a public folder with access for all users and other folders that have restricted access. I have an Excel workbook in a restricted folder, and I want to put another workbook ...
0
votes
2answers
324 views

Rich Text field in Infopath customized form adds blank lines in Excel

I have a fairly basic custom list in Sharepoint 2010 which contains a rich text field. I have customized the form with Infopath. Now when I export to Excel I find blank lines preceding the text. ...
1
vote
1answer
633 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 ...
2
votes
1answer
34 views

Excel files are not previewed in office web apps

I have a document library with 10,000 excel files all the files have some macros for calculation in Sharepoint 2013. When I search on that site collection, sometimes I get a preview, sometimes I ...
2
votes
2answers
58 views

Is there a way to start a SharePoint workflow from VBA code?

I created a tool in Excel VBA that generates a custom report from the data I pulled from a SharePoint list via Excel VBA code. What I want to do is change/update the "Status" field for items within ...
2
votes
0answers
48 views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
1
vote
1answer
34 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
613 views

Export to Excel for sharepoint 2010

Export to excel was previously not working for clients that were using Office 2007 because we we are using claims based authentication. A few days ago a few clients noticed that the export to excel ...
1
vote
1answer
34 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 ...
0
votes
1answer
14 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
0
votes
1answer
85 views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
3
votes
4answers
3k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
0
votes
0answers
26 views

Export to Excel ignoring filters

I understand that when we use the Export to Excel button in the ribbon bar, what we get is an IQY file containing a query for OWSSVR. I am trying to filter the data returned by OWSSVR. When I go to ...
1
vote
1answer
55 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
6
votes
5answers
18k 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 ...
1
vote
0answers
15 views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
2
votes
3answers
8k views

How can I share an excel document with my team to edit?

I would like to know if something is possible and where to start. Each day, my boss sends out a spreadsheet listing our data entry errors for the previous day. All five of us download the sheet, make ...
1
vote
0answers
54 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
4answers
8k views

Import from Excel to an existing list

I'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient. Any ...
1
vote
0answers
13 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
1answer
36 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
3answers
4k views

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template?

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template? I just want to see how it works.
1
vote
1answer
27 views

How to create an Excel Document when adding a Library Item?

Hope you can help me with this question: I have a SP Library, where the user should type info into some fields (Text, Publishing HTML, Datetime). So, I'm wondering if it's possible to use that info ...
1
vote
1answer
22 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.
0
votes
1answer
76 views

Collect data from SharePoint and make from that a report

I want to create a report , the data source will be a SharePoint list . I tried to use the PowerBI (unfortunately , its configuration is not going so well) , then I thought about Excel (a combination ...
0
votes
3answers
5k views

Import Excel to SharePoint list -> Auto-synchonize based on Id

Are there tools available for importing an Excel file to a SharePoint list so that the importing data would be synchronized based on specified field(s)? I would mostly be interested in a ...
1
vote
1answer
24 views

Port change from 80 to 443 causing endless user prompting when accessing office files

This weekend I changed the main web application to run on https instead of http. This morning when some (not all) users try to check out or edit and office file they are continually prompted for ...
0
votes
0answers
41 views

How to edit or disable link in Excel Web App header?

SharePoint 2013 Office 365 Users click on a tile/link on home page and link is connected to a spreadsheet. So the MS Excel Web App opens the file. In the upper left corner after the 'Microsoft Excel ...
0
votes
2answers
85 views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
1
vote
1answer
68 views

can we make it “export to spreadsheet” in sharepoint list automated?

my client wants it automated so that the exported csv file will be saved periodically into a location and he can do his necessary action. rather than coming into the site and exporting it each time. ...
0
votes
1answer
27 views

SP13: Overwriting Excel Importing List

This task seems easy, but is turning out to be more complex than I expected. I have a excel spreadsheet that I have imported into a custom list. In order to import the excel spreadsheet by using ...
1
vote
0answers
22 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 ...
3
votes
1answer
80 views

How to export speific rows of a list to excel (using OOTB)

I need to create a list with "Export" as a column. (Export column should be a hyperlink field). Once user clicks on "Export" field value, then that specific row data should get exported to excel 2010. ...
0
votes
2answers
77 views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
24 views

SharePoint 2007 - Users losing data in excel files

We have a SharePoint 2007 in our environment and our users are reporting that they will make changes to excel files and will go back the next day and the changes will be gone. This happens randomly ...
0
votes
0answers
66 views

Export external lists from sp2013 to excel

we are currently trying to get SharePoint up and running, and after our ERP/database guy set up a few external lists that query our ERP database, some of our users had trouble exporting those lists to ...
0
votes
0answers
22 views

Is it possible to edit excel file on SharePoint online from iOS app?

Currently, I am developing an iPad app which can manipulate excel file that is stored on SharePoint online service. I am able to retrieve data from excel file using Excel Services REST API, but when ...
0
votes
3answers
38 views

How to export list items in same order in a list to excel 2010 (console application)?

I require to export list items from a SharePoint list to Excel. The order of items in the Excel sheet should be the same as in the list. Can somebody suggest console application code for this?