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

learn more… | top users | synonyms

3
votes
0answers
6k 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
1answer
14k 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
4answers
13k views

Export to excel - large lists

I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...
2
votes
3answers
10k 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
6answers
16k 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

Using firefox to edit office documents inside my document library

I have a problem in understanding what is the standard approach to follow for editing office documents inside my document library. As it seems each browser will have different behavior when it comes ...
2
votes
1answer
5k 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 ...
2
votes
2answers
5k 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
6answers
18k 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
2answers
483 views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
2
votes
1answer
963 views

Can I edit a workbook using Excel Services?

I created a web part putting my Excel worksheet on one of my Document Library, so I can have the live view of that worksheet without opening it again and again, my question is, can I edit that ...
2
votes
1answer
86 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
1answer
287 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
1answer
2k views

Generating Excel Export using a link?

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can ...
2
votes
2answers
7k 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
2k 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
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
1answer
30 views

How to populate Excel 2013 sheets in SP2013 library with data from Access database on SP2013?

I'm new to Sharepoint. I may not use the right terminology and sound like an idiot. Please be kind. (I'm a former JEE developer. I understand the basic concepts. Just not sure how to translate them ...
2
votes
1answer
63 views

How to Export a Document Library to Excel from SharePoint 2010 using a custom button?

I need to do the same as this little fantastic button in the sharepoint ribbon. It allows users to export a document library to an excel spreadsheet. I posted a screenshot below. I would like to ...
2
votes
1answer
50 views

From Excel 2010 is it possible to attach a PDF file to a list item.

I have the list item ID and I have the location of the PDF file, it is created using the excel sheet and now I want to attach it to a list item.
2
votes
1answer
4k views

Publish and Synchronize Excel 2013 as Sharepoint List

Can we publish and synchronize excel 2013 table as SharePoint list. I understand that using export to excel functionality and using data connection changes in the list gets reflected in the excel. But ...
2
votes
2answers
49 views

Is Claims-based authentication Required for Kerberos and Excel Services?

I'm trying to setup Kerberos for Excel Services + SSAS. SharePoint Web Application pool using Classic Authentication. I was wondering if it's necessary to switch it to claims-based. I've found zero ...
2
votes
1answer
3k views

Automatically Import Excel Data to SharePoint List

This question has been asked before but I haven't found an answer that works for me and my limitations. I have an excel spreadsheet that is currently being used to input data with 20+ records each ...
2
votes
1answer
2k views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
2
votes
1answer
225 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
3answers
2k 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
218 views

Embedding an Access database in SharePoint?

I have a client who would like me to embed an access database from another location (document library) to a SharePoint page in an editable format. Similar to how you can add the "Excel Web Access" web ...
2
votes
1answer
4k views

Creating a link between an Excel spreadsheet and a list

I have a query regarding something I’m not sure is possible. Hopefully somebody can tell me whether that is the case or not. We have an Excel document that we issue to suppliers after an audit, ...
2
votes
1answer
3k views

Can't open excel file in edit mode, currently open by 256 users

I got an issue from one of my users, where he would get the following message whenever he opened a particular excel file stored in a document library. The workbook is currently open by 256 users. ...
2
votes
1answer
3k views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
2
votes
1answer
802 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
437 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
2answers
706 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
2
votes
1answer
1k 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 ...
2
votes
1answer
66 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 ...
2
votes
1answer
13k 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 ...
2
votes
1answer
1k views

Update existing list in Sharepoint 2010 with Excel or Access 2007?

I'm looking for ways to update an existing list in SharePoint by using either Excel 2007 or Access 2007. I have seen plenty of ways to create a new list, but nothing about updating existing lists. ...
2
votes
1answer
33 views

Export list to Excel - 50'000 limit

We have a user that has a SP2013 list with nearly 100'000 items. In a previous SP2007 environment, they could export the entire list to excel. In SP2013, they are hitting a hard limit in Excel of ...
2
votes
0answers
44 views

Sharepoint Excel file opens Read Only when edit is selected

A user on a team sharepoint who has contribute permissions is getting a 'read only' version of ONE of the files in a folder. All other users can open normally and edit. However, when this user selects ...
2
votes
0answers
16 views

Synching select rows from an Excel spreadsheet into a SharePoint 2013 List?

I know you can connect Excel and SharePoint 2013, but is there a way to "selectively" sync data from an Excel Spreadsheet into a SharePoint List? Basically, we have a master spreadsheet where each ...
2
votes
2answers
39 views

Sharepoint formula limit help

i've been making this formula(based on previous questions) which works great(with 3 id's), But when i try it with all my id's it give me an error "Cannot complete this action". Can anyone help me out? ...
2
votes
0answers
135 views

Excel and PowerPoint to talk via SharePoint Libraries

We are looking into a way for an Excel file and PowerPoint file to exchange data. I'm thinking Excel Web Services, OpenXML, SharePoint Office Apps and/or maybe CSOM. Requirement is coming up to: ...
2
votes
0answers
81 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 ...
2
votes
0answers
604 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 ...
2
votes
0answers
249 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 ...
2
votes
0answers
81 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.
2
votes
2answers
1k 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 ...
2
votes
0answers
431 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
298 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 ...