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

learn more… | top users | synonyms

2
votes
2answers
1k views

Export custom list to excel

I'm using SharePoint 2007. I have created custom-list. The list contains one column from "Person and group" type, show field: E-mail. I fill in data in the list column and export this list to excel ...
6
votes
4answers
10k views

How to migrate a 2007 sharepoint list to 2010?

We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010. what's the best and fastest method? thanks in advance
3
votes
3answers
19k 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 ...
1
vote
1answer
339 views

IF AND CONCATENATE Nested Statement in Calculated Column SharePoint 2010

I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files ...
0
votes
2answers
1k views

Excel file opening in XLViewer for some users

We have a corporate internal portal with lot of subsite and document library for various department/BU. When a user tries to open a excel file from a document library it opens in Excel client from ...
3
votes
3answers
19k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
2
votes
1answer
9k views

Making a link from SharePoint site to Excel file on Shared Drive

Even though solution to this might not be SharePoint related, but thought to ask here anyway in case someone has some thoughts. I'd like to make it possible to open certain Excel macro-enabled ...
0
votes
1answer
291 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...
0
votes
1answer
118 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
692 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
41 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
191 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
181 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
34 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
156 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 ...
1
vote
1answer
3k 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
331 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 ...
0
votes
1answer
130 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
0answers
179 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 ...
2
votes
2answers
5k 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 ...
2
votes
1answer
216 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
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

Update List from Excel using VBA

I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...
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
249 views

How to prevent users from getting at the source files for Excel Web Services

I have a request to put a large Excel dataset on a MOSS 2007 sharepoint page. The XLSX is about 13 MB in values alone - about 50,000 rows. It's updated weekly, usually in batch form (i.e. some ...
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
1answer
54 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
368 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
177 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
327 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
310 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
1answer
3k 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.
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
60 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
2answers
1k views

List containing Managed Metadata when exported to Excel using Ribbon, has weird hash tags - how to clean?

I have a calendar All Events list which contains few fields, some from Managed Metadata and People presence lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each ...
1
vote
1answer
1k views

SharePoint 2010 Issue with CSV File

We are using SharePoint 2010. I have permission (full access) on my site. I have three uploaded files (one Word .doc, one Excel .xls, one CSV .csv). I had no problems editing Word and Excel files. ...
2
votes
1answer
166 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.
1
vote
1answer
574 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 ...
2
votes
0answers
67 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
7k views

Permission levels for user exporting list into excelsheet sharepoint 2010

What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
1
vote
0answers
114 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
57 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
117 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
93 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
254 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 ...
1
vote
2answers
260 views

Ability to migrate linked Excel spreadsheets to MOSS

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
2
votes
0answers
462 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 ...