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

learn more… | top users | synonyms

0
votes
3answers
278 views

Can we create Excel file using c#?

I would like to know if it is a good idea to create an excel file using c# in sharepoint? I've tried to find js libraries but despite ExcelBuilder which seems really complicated to use i can't find ...
1
vote
0answers
564 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
0answers
1k 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 ...
0
votes
1answer
50 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
1answer
76 views

Prevent User saving excel document back to Sharepoint

I have users on Excel 2010 and they are accessing a sharepoint site using Sharepoint Services 3.0 and clicking on the excel document and the default behaviour is to save this back to sharepoint rather ...
0
votes
0answers
28 views

save excel spreadsheet to cs to sharepoint server

I am trying to save an Excel spreadsheet to .csv to a SharePoint server but running into issues Within an Excel document, I go to: File > Save As > change the file ‘save as type’ to csv (comma ...
0
votes
1answer
75 views

Filling SharePoint Calendar List With Bulk Data(About 3000 Entries)

I want to fill about 3000 entries in a SharePoint calendar List for testing purpose. I have tried using this link but i have some lookup columns and person/group fields which do not appear in the ...
0
votes
1answer
182 views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
0
votes
0answers
225 views

Excel Online - refresh data in a SharePoint list

I have added a SharePoint list to an excel spreadsheet as an odata feed. This data connection refreshes perfectly using Excel on the Desktop. However, when I refresh the connection in the Excel web ...
0
votes
0answers
894 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
3k 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 ...
0
votes
0answers
59 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
62 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 ...
0
votes
1answer
33 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
55 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
22 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
26 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
22 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
637 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. ...
2
votes
1answer
134 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
192 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 ...
1
vote
1answer
123 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
211 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
43 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 ...
3
votes
4answers
5k 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
77 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
186 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" ...
3
votes
3answers
11k 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
304 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
10k 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
22 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
207 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
105 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
38 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
95 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
6k 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
31 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
85 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
209 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
1k 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
87 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
41 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
946 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
653 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
55 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
196 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
54 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
69 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?
2
votes
0answers
64 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 ...
0
votes
0answers
172 views

Can't connect to sharepoint for data refresh since upgraded to Excel 2010

I use Microsoft Enterprise Project Management (EPM), which is based on SharePoint Services and started having problems after upgrading my local machine Office from 2007 to 2010. I can normally ...