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

learn more… | top users | synonyms

0
votes
1answer
88 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
0
votes
0answers
172 views

Excel error: Cannot connect to the SharePoint list

I am trying to export some data from external list to Excel 2010 and the error is: Cannot connect to the SharePoint list (My SharePoint Server is 2013). However when I do that within Excel ...
0
votes
0answers
22 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
0
votes
0answers
19 views

Linking to sheet number 2 on an embedded Excel Web Access

I want to link to one of my sheets in an embedded spreadsheet (using Excel Web Access) from another page - is this possible?
0
votes
1answer
390 views

Excel Online - Enter Array Formula

In Microsoft Excel entering an array formula requires using the keyboard combination: Ctrl Shift Enter How can I enter an array formula in Excel Online (the WebApp version of Excel). Is there ...
0
votes
1answer
109 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
344 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
45 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
210 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
2answers
3k 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
1k 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 ...
0
votes
1answer
37 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
1answer
3k 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 ...
0
votes
1answer
93 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
1answer
304 views

Synchronize excel file with SharePoint online list

I want to synchronize data from excel file with SharePoint list on office 365. I have already built a utility which uses client object model to achieve this but it is very slow as item count are in ...
0
votes
1answer
99 views

Get Chart web part to dynamically change with original share point list

I have a sharepoint list that contains a list of projects and their technology. Example. P1 - Java P2 - SAP P3 - Oracle P4 - Java p5 - Oracle I want to be able to represent the Tech distribution ...
0
votes
0answers
70 views

How to synchronize an excel spreadsheet with SharePoint 2010?

I have a spreadsheet being fed by several SQL Queries. After the queries are run, the fields repopulate and I have Graphs/Charts and formulas that visually display the data. I'm trying to simply ...
0
votes
1answer
643 views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
0
votes
1answer
2k views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
0
votes
2answers
1k 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. ...
0
votes
2answers
102 views

Excel signature lost when opened from sharepoint 2010 [closed]

I hope you can help me to understand this issue. I have a digitally signed Excel document. It is marked as final, it contains one signature. I uploaded that document to sharepoint 2010 document ...
0
votes
1answer
305 views

Search excel spreadsheet or Microsoft access within sharepoint

I have a spreadsheet with a list of batch jobs. I was wondering if it's possible to create some type of search into a sharepoint to search this spreadsheet. We are using sharepoint and if I could have ...
0
votes
1answer
71 views

Link Excel to SharePoint 2010 list content

I have an Excel document that is linked to my SharePoint 2010 list. Recently my list climbed over the 5000 limit so I had to add some filtering to my view. This negatively impacted my Excel document ...
0
votes
0answers
2k views

Excel File Opens as an Offline Copy

For some reason, when I check out or open (Read Only) this one Excel file in a document library, it opens as an "offline copy". The File menu in Excel says it's an "Offline Copy: Workbook is in ...
0
votes
1answer
41 views

Co-authoring in Excel, OWA

After installing Office Web application in my SharePoint server 2010, we are unable to co-authorise with Excel. But this co-authorise function works with Word and PPT. Is there any setting we need to ...
0
votes
0answers
1k views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
0
votes
1answer
137 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
0
votes
0answers
204 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
2answers
29 views

French excel numbers being changed to english when uploaded to SharePoint, how to fix?

I have a site where I've uploaded an excel document that was translated by one of the companies we use and once I uploaded it to my SharePoint site but the column that contained numbers changed to ...
0
votes
1answer
410 views

How to convert Sharepoint 2010 Chart web part to Excel?

I want to convert chart webpart's chart to excel format how it is possible?
0
votes
0answers
61 views

Sharepoint link issue

I am having a weird issue. I uploaded an excel document to sharepoint, and when I click the link it does not do anything, however if I right click open in new tab it opens. ** This is an excel ...
0
votes
1answer
121 views

How to refer to a local file for a PowerPivot datasource?

We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state: Type the connection string to the PowerPivot data source by ...
0
votes
1answer
689 views

How to update Excel Sheet In SharePoint 2010 (Sharepoint Online)?

I am working with SharePoint Online(Office 365). I have some Excel files uploaded in a SharePoint library and I need to update one of the file data using c# code. My solution in Sandbox solution. I ...
0
votes
2answers
224 views

Export SPGridView to Excel tabs

I have multiple SPGridViews on a page. I would like to export them all to one Excel document, each SPGridView on its own tab. Is this possible? This link is a great start but does not solve my tab ...
0
votes
1answer
140 views

Create Date Field when using Data Connection in Excel

I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel. The technique I am using is to go to the list and export it from the ribbon ...
0
votes
0answers
1k views

How to export filtered list data to Excel

I have custom application page. There are few datepickers, to filter custom list data. When user clicks on Export To Excel ( which is asp:Button ) I need to filter data based on datepickers value, and ...
0
votes
0answers
257 views

Error message :File extension changes to .aspx on opening any excel or word file in a sharepoint document library

I have a document library in Sharepoint 2007 which consists of few word and excel files. Whenever i try to open a file, it shows the message " the file [filename.aspx] you are trying to open is in a ...
0
votes
0answers
835 views

Import Excel as List Fails

I have an Excel Spreadsheet that I want to import into SharePoint 2010 as a list but upon doing so I receive the following errors. As a work around I have saved the spreadsheet as csv and then ...
0
votes
1answer
95 views

Can published excel be modified from with in sharepoint?

I have an excel table that i wish to publish which displays our users call stats on a certain date. Change the date cell and the table refreshes through a series of IF statements from the data tab. ...
0
votes
0answers
231 views

Import from Excel Spreadsheet works in IE6 not IE8

I'm having an issue in SharePoint 2007 in IE 8 where, when creating a new List using Excel Spreadsheet Import, I get redirected to a 403 error. This feature works in IE 6 but not IE 8. Can anyone ...
0
votes
2answers
3k views

Sharepoint seeking authentication when opening Word / Excel files from website

The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific ...
0
votes
2answers
34 views

Pasting excel rich text column into Sharepoint 2013 list edit view

I was trying to paste an excel table to SP2013 datasheet view with one of the column is enhanced rich text editor. But the view stripped out the styling from excel table. Excel table: This is the ...
-1
votes
1answer
171 views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
-1
votes
2answers
20 views

Excel Web Access issue

I embedded an Excel sheet into SharePoint using the excel web access web part. It works great, the only problem is that it continues to display the Excel sheet on refresh where it was last saved. I ...