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

learn more… | top users | synonyms

0
votes
1answer
108 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 ...
2
votes
1answer
604 views

Document Library containing Managed Metadata when exported to Excel has weird characters

We have document library for storing assets in it. Document Library contains some of Managed Metadata lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the ...
1
vote
0answers
38 views

Sharepoint 2010 issue with exporting certain combination of columns from a view

so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...
1
vote
0answers
161 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
165 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
19 views

How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service

We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...
1
vote
2answers
4k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
1answer
33 views

Displaying Version # In Document

I am looking for a way to display the SPItem version number from within an Excel document. We are authoring an Excel Template in a version controlled document library. I want the Excel document to ...
2
votes
0answers
140 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
4
votes
1answer
2k 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
1answer
296 views

Error exporting list to excel - permissions for resource throttling ceiling

What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
2
votes
1answer
381 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
0answers
171 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 ...
1
vote
1answer
2k views

Documents Not Prompting to Check Out and Not Saving

I am getting strange behavior on some of my users machines when they attempt to edit an Excel workbook from SharePoint. When the user clicks on the document link it opens the workbook in Excel and ...
0
votes
1answer
37 views

Open documents in client unusual behavior

I recently modified settings at the list level to force documents to open on the client. After I tested the behavior while logged in as an Admin and it seemed to work fine. Today however an end user ...
3
votes
3answers
16k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that are ...
2
votes
3answers
5k 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
2answers
2k views

Fail to export custom SPList to Excel

Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
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 ...
2
votes
2answers
4k views

SharePoint 2010 error when importing excel spreadsheet to sharepoint list

I get the following error when trying to import an excel spreadsheet into a SharePoint list. "The specified file is not a valid spreadsheet or contains no data to import" I have added this site to ...
1
vote
1answer
4k views

Why are .xlsm files opened as read-only when .xlsx are not?

I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
2
votes
1answer
53 views

Creating lists within lists, or tables within lists, or…?

I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having ...
1
vote
2answers
357 views

Import a single row from Excel spreadsheet

I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row! Is ...
1
vote
0answers
163 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
0
votes
1answer
301 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?
1
vote
1answer
2k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
280 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
2
votes
4answers
17k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, ...
2
votes
1answer
2k views

SharePoint List Export to Excel All Columns!

As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
0
votes
1answer
940 views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
1
vote
0answers
25 views

Import excel spreadsheet with photos

I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos. What am I doing wrong?
0
votes
0answers
59 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 ...
2
votes
1answer
148 views

Simple Way to Get Data from WSS 3.0 List to Excel via Web Services

Is there any simple way to get live data from a WSS 3.0 list into Excel via web services or am I going to need to write code? I understand I can export the list data, that is far too manual.
2
votes
0answers
66 views

Writing excel 2003 vba to extract a Sharepoint list to Excel

I'm trying to find some Excel 2003 VBA that will let me inport a sharepoint list into Excel so that I can perform some basic tasks on that data.
4
votes
2answers
2k views

Run an Excel Macros from SharePoint

I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
2
votes
1answer
2k 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 ...
1
vote
0answers
107 views

How to get my deleted columns back in an Excel file, that were exported from SharePoint lists

I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I ...
1
vote
0answers
49 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
3
votes
1answer
114 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 ...
0
votes
1answer
88 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 ...
2
votes
0answers
246 views

How to make a List Column link to Excel Cell

I have a SP library that lists the names of various excel spreadsheets. Each spreadsheet has a cell that reflects the percentage of completion for a project. I also have a SP list of projects, which ...
2
votes
1answer
207 views

How to import one single row of data from excel to one list item in a SharePoint 2010 list?

I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
0
votes
3answers
7k views

Cannot open word document and Excel from Sharepoint 2010

I am not able to open any word documents and Excel from my Sharepoint2010 sites. I was able to open them before I re-installed everything from scratch. When I try and open any uploaded Excel document ...
2
votes
0answers
427 views

offline and online (SP 2010) version of Excel with slicer

An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend. The browser gives following error. "The workbook cannot be opened ...
0
votes
1answer
399 views

SharePoint 2007 List export to Excel 2007

Good Morning, I exported the contents of a SharePoint list to an Excel worksheet; however, I noticed the colors and formatting that have been applied to the data. This was done automatically as a ...
1
vote
1answer
544 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
1answer
120 views

Excel Calculation Services - Excel Web Apps

We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
1answer
211 views

Migrate Excel Docs from Shared Drive to Sharepoint Foundation 2010?

I have a fairly large shared drive with various files that need to be migrated over to SharePoint. I only have full control of my site, which is a subsite within the hierarchy. I feel like if I were ...
0
votes
2answers
192 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
2answers
1k views

Excel web part from list - Autorefresh

I am using SharePoint 2010. I currently have a list that gets updated many times throughout the day. I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data ...