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

learn more… | top users | synonyms

0
votes
0answers
74 views

Excel Web Access Error message

I use SharePoint 2007 and have used Excel Web Access to link to a spreadsheet for a few months. It's a rota so is updates every few months and all I do is change the file path to match the new file ...
0
votes
0answers
182 views

Unable to refresh SPO 2013 Excel Web external oData source

First of .. I see the Excel Web access webpart on SPO 2013, but is Excel Services available on SPO 2013 and if so, where is it and how do you enable it? So, I have this cloud test users. I ...
0
votes
0answers
173 views

excel odata connection to sharepoint online custom list - How do I return all rows in an SPO 2013 to excel 2013

How do I return all rows in an SPO 2013 list to excel 2013? I'm trying other sources > odata and can get some things, but not all rows. ...
2
votes
0answers
47 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
0
votes
0answers
51 views

How to recover files saved but not checked in on a Mac?

I have an Excel file that I checked out and opened in Edit mode directly from Sharepoint on my Mac OSX. I was saving along the way. However, Excel then crashed before I was able to close the file and ...
1
vote
0answers
163 views

Cannot Save Excel to Sharepoint

One of my users is having an issue saving to Sharepoint with some very specific parameters. the problem is related to saving only from within excel if a document has been opened from SP. She is ...
0
votes
0answers
484 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
0answers
42 views

Metadata not saving thorugh Excel 2010 on one column

Me and some colleagues are finding that when we save a document to SharePoint 2010 with Excel 2010 one of the meta data columns does not save properly. In SharePoint it says the column is empty but if ...
3
votes
4answers
14k 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 ...
2
votes
2answers
847 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
9k 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
0
votes
0answers
50 views

How can I modify a Excel Web Access Web Part client side?

Hello I'm just getting started in Sharepoint 2013 development. Currently, I am trying to display a spreadsheet in Excel Web Access. The spreadsheet displayed is determined by a session variable. ...
0
votes
0answers
86 views

How to insert documentID in an excel file, for each new created excel document in a document library?

I have a sharepoint 2010 portal. I know it is possible by quickParts to insert metadata in a Word document. See also these tutorials: ...
1
vote
1answer
183 views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
2
votes
3answers
9k 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
180 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
0answers
26 views

Add-in disappearing from the excel spreadsheet

We have installed an Add-in to excel spreadsheet which appears on the ribbon with a new tab called 'Add-Ins'. But we started having problems with the add-ins/macros disappearing either when a new ...
0
votes
2answers
865 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
14k 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
6k 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
162 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
168 views

Sharepoint 2010 / Google Chrome / Excel

From one of our users: Now that many of the items seem to work with Sharepoint and Chrome, one of the biggest outstanding issues is that it wants to open the documents in the browser by default. ...
0
votes
1answer
98 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
443 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
32 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 ...
0
votes
0answers
185 views

Import Sharepoint (WSS3.0) List into Excel 2010 using a specific view name

I'm trying to create an Excel highlight report reading lists from a SharePoint 2007 (WSS3.0) site. This is a Excel workbook that is used as a template for different portals. With help of this post: ...
0
votes
0answers
203 views

Excel Services - How to remove cached dataset

I need to reflect role-based security in Excel Services, but I have an issue with caching of the Excel workbooks, so a user without access to models/cubes sees the initial dataset inside the ...
1
vote
0answers
109 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
96 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
14 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
3k 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
32 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 ...
0
votes
0answers
32 views

Publishing Named Ranges Programatically

I have a document library containing excel files with named ranges. I created some excel web parts programmtically and linked these excel web parts to my excel files in my document library. My ...
2
votes
0answers
111 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
1k 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
220 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 ...
1
vote
1answer
293 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
1answer
109 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
144 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
3k 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
185 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
36 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
13k 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
1k 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
207 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 ...
1
vote
1answer
6k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
2
votes
1answer
51 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
320 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
115 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 ...