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

learn more… | top users | synonyms

7
votes
6answers
26k 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 ...
7
votes
2answers
5k views

Adding document version number on Excel Spreadsheet as label for printing purpose

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document. I ...
6
votes
4answers
11k 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
5
votes
7answers
22k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
5
votes
0answers
90 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
5
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 ...
4
votes
2answers
8k 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?
4
votes
1answer
465 views

Excel Services - when/where image of chart created?

When using Excel services (REST or the webservice) a chart is displayed as an image. Where/when is this image actually created? I'm asking this, because I was wondering if I can change something in ...
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?
4
votes
1answer
3k views

Documents library wants to open Excel file in XLViewer

We've added some Word and Excel documents, as well as PDFs to the default Documents library in a SharePoint 2010 publishing site. However, SharePoint wants to open the Excel files in the built-in ...
4
votes
3answers
3k 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 ...
4
votes
2answers
927 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
3
votes
4answers
16k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
3
votes
1answer
2k 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. ...
3
votes
3answers
6k 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.
3
votes
3answers
22k 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 ...
3
votes
3answers
20k 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 ...
3
votes
3answers
12k 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 ...
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 ...
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 ...
3
votes
2answers
232 views

Row Labels are blank in PivotTable from Analysis Services

I have Team Foundation Server 2010 and SQL Server 2008 SP2 installation and am looking at the out-of-the-box Excel Reports for an Agile project. All of the Excel Reports connect to the TFS OLAP cube ...
3
votes
1answer
25 views

Reusable Tasks - moving an process from excel workbooks to SharePoint

My team use a SharePoint 2013 team site. Currently when we deliver training we use an excel workbook which tracks student names, and tracks their scores and has a standard task list of content that ...
3
votes
2answers
1k views

We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Interactive report sheets

I use SharePoint 2013 and Power Pivot Services. I create a Excel report with Power Pivot and I fetch data from my Data Warehouse. I upload this Excel file in SharePoint Documents. For update my ...
3
votes
1answer
2k views

Cannot Edit Excel Document with Full Control Permission

There is a document with permission. User A and User B can only edit the document after they open from sharepoint. User A has Excel 2013 in his PC. When he opens it in Excel it says "The document is ...
3
votes
1answer
122 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 ...
3
votes
1answer
2k views

SharePoint 2010 Excel Web Access “Automatically reloading workbook”

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing. However, every time ...
3
votes
1answer
444 views

Why does using Actions > Edit in Datasheet result in <div> … </div> HTML formatting in the multiple row text area?

I have a SharePoint List with a column of type 'Multiple lines of Text'. Then I copy a Excel spreadsheet content into the List using Actions > Edit in Datasheet. Later, when I use a HTML text-area to ...
3
votes
1answer
232 views

How to configure Excel and SharePoint to access remote databases

I am using Excel to render data stored in a PostgresQL database elsewhere on our network. In general, the rendering works. However, I haven't been able to get the document to automatically ...
3
votes
1answer
663 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 ...
3
votes
1answer
978 views

Check in error “We can't do that becuase the file is no longer checked out or has been deleted”

First question ever from this rookie, please be kind. Sharepoint 2013, Office 2013 Std 32 bit. Win7 Pro 64bit Sp1. I've got an issue with checking my .XLSX file back in after any edits. Error message ...
3
votes
0answers
3k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
3
votes
2answers
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 ...
3
votes
1answer
13k views

Documents open read-only when user should have write access

Scenario: We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web ...
2
votes
3answers
7k views

create button that export custom list to excel file

I'm using sharepoint 2007, custom list. from the datasheet view I can export the list into excel/access file. is it possible to create a button that proposes to export the list to excel. (in order to ...
2
votes
7answers
13k views

Importing an Excel file to a list - how to control the column types

I am attempting to import an Excel file into SharePoint using Create List > Import Spreadsheet. Several columns are just short text fields < 100 chars and with no formatting/line breaks etc. Some ...
2
votes
2answers
3k views

Working with data imported from Excel into a SharePoint List

I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
2
votes
1answer
54 views

help Column formula in sharepoint list

So i asked this question a couple hours ago: I have made a list with InfoPath in SharePoint. All the questions are either "accepted" or "notaccepted" (radiobuttons) and I want to make a new column ...
2
votes
4answers
1k views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
2
votes
1answer
106 views

Excel web app Sharepoint Online

I am currently implementing some Powerview in excel that is used on sharepoint online. My problem is that I can't get excel web app to save automatically when something is changed in excel web app ...
2
votes
3answers
17k views

Disable Excel Web Access?

Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise) I have enabled the "Open in Client Applications" feature and it works fine in ...
2
votes
3answers
2k views

Excel import to SharePoint

I'd like to be able to import a spreadsheet from Excel into SharePoint and be able to select a list template I've already built. Is this possible? I need to be able to do this so the proper ...
2
votes
2answers
302 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
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
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.
2
votes
1answer
173 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
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 ...
2
votes
1answer
44 views

Analytics on contents of spreadsheets in a MOSS library?

I have a requirement from a business user that I don't know how to address. The question is this: Can I count the number of times a specific value appears inside the spreadsheets stored in a ...
2
votes
1answer
362 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
1answer
285 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
2
votes
1answer
808 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 ...