Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
6
votes
1answer
15k views

Import/Copy/Paste Data from Excel into Existing SharePoint List

How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
16
votes
9answers
119k 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 ...
6
votes
2answers
66k 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 ...
4
votes
3answers
27k 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 ...
11
votes
9answers
72k 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 ...
8
votes
3answers
41k 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 ...
2
votes
2answers
4k 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 ...
12
votes
8answers
274k 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, but ...
7
votes
2answers
27k 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?
6
votes
3answers
8k views

Link on wiki page to Excel document that opens in Excel Online

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online. When I create the link using Insert -> Link ...
3
votes
4answers
17k 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 ...
0
votes
1answer
682 views

How can I search an Excel spreadsheet in SharePoint?

Looking to be able to search an Excel spreadsheet from the SharePoint mobile app. I have a spreadsheet with Postal Codes/Zip Codes with corresponding information. I would like to be able to search as ...
0
votes
3answers
288 views

Export table to exisiting sharepoint list from excel

Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
7
votes
3answers
63k views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
0
votes
2answers
7k 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 ...
7
votes
4answers
11k views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
7
votes
4answers
16k 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
1
vote
2answers
25k views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
6
votes
1answer
9k 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 ...
5
votes
0answers
9k 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
227 views

how to export BI report to excel

We deployed bi dashboards in our web application using the performance point service and it enable annonymous acess for users without login they can view. but when they trying to export it ask ...
2
votes
2answers
4k 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 ...
2
votes
1answer
6k views

Unable to refresh data in Excel Online connected using Power Query

I have prepared a chart in Excel, connected using Power Query. In Power Query I have used oData connection to get a SharePoint Online List to get the data. Now I save the Excel into Office 365 ...
0
votes
1answer
300 views

SharePoint 2007 - Users losing data in excel files

We have a SharePoint 2007 in our environment and our users are reporting that they will make changes to excel files and will go back the next day and the changes will be gone. This happens randomly ...
6
votes
1answer
7k 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 ...
5
votes
2answers
12k 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
2answers
6k 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. ...
3
votes
4answers
73k 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 ...
3
votes
4answers
6k views

Export mulltiple lists onto same sheet in Excel?

so I know we can export a single list to an Excel Spreadsheet, but is there a way export multiple lists on that same spreadsheet?
3
votes
1answer
5k 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 ...
3
votes
2answers
2k views

Excel file corrupted after uploading to Sharepoint with Python

Similar to this question I'm having trouble opening a file uploaded via Python onto SharePoint. This is the code I'm using to upload the file: import requests from requests_ntlm import HttpNtlmAuth ...
2
votes
1answer
8k views

Cannot connect to the server at this time, you're table cannot be published

I created a list in SharePoint Online, I'm using the url to the list but I receive this error when trying to export from excel. URL example: https://mysite.sharepoint.com/sites/mysite/lists/...
2
votes
1answer
2k views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
2
votes
2answers
8k 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 ...
1
vote
1answer
3k 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 ...
1
vote
1answer
85 views

Automatically add an excel file as one part of a list item in SharePoint

In order to streamline my company's request process, I am setting up a few lists on SharePoint. Essentially what I am trying to do is set up this list so that whenever an employee adds an item, a ...
1
vote
0answers
123 views

Import Version History from Microsoft Excel to SharePoint 2013 List Items PowersShell

I have all the list items and Version History in the Excel file. I have added the items to the list with PowerShell. Now I have to add version history to the list item with PowerShell. How to ...
1
vote
2answers
5k 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
2answers
1k views

Interacting with Excel spreadsheet from Sharepoint 2010

I'm wondering is it posible to create or modify Excel spreadsheets that are on SharePoint 2010 programaticaly and how to do it?
1
vote
2answers
1k views

Convert list data to excel and upload it to document library without downloading

I have a requirement to export my list data directly to document library as new Excel document. I have used the following code to export to excel function getLists() { context = new SP....
1
vote
1answer
443 views

Issues in some contents of Excel web access web part in mozila firefox and google chrom

Whenever we create an Excel web page, using Excel web access web part, we got an option "open in excel". That "open in excel" option is not working in google chrome but it is working in Internet ...
1
vote
2answers
3k views

How to show version number when using 'Export to Excel' command

my firm is transferring a project to another firm. The new firm wants a list of all of our files. I went into our sharepoint library and selected "Export to Excel" which returned a spreadsheet with ...
0
votes
1answer
1k views

Choice field data contains # when exported to excel

I have a choice field(checkbox, multiple values) in a SharePoint List. In SharePoint values are displayed as Choice1, Choice2. When exported to Excel the format used in Excel is Choice1,#Choice2 I ...
0
votes
2answers
901 views

VBA Excel Retrieve SharePoint User Number By Name (not User Information List)

Below, I've got a little job to insert a record into a SharePoint list. The Requestor field is a "Person or Group" type field, and in the code, the... rst![Project] = Sheets("Sheet2").Range("B2")....
0
votes
1answer
52 views

Update URL's link Inside Office (docx, xlsx) documents

We need to change the root of our SharePoint 2013 Document Management site collection due to a company ownership change from Sharepoint.acb.net to Sharepoint.xyz.net. I configured everything using the ...
0
votes
1answer
2k views

How to handle Excel sheets with macros

We have an Excel sheet with Macros on it. We uploaded the Excel sheet into SharePoint Document Library. When the Excel is opened using Excel Online, Macros do not work. So in order to make Macros work ...
0
votes
3answers
6k views

Export selected item from list to excel

I'd like to know if there are a way to export to excel the selected items in a sharepoint list i'm in sharepoint 2010
0
votes
2answers
3k views

Open a specific Workbook in Excel online using the URL in SharePoint online Excel Workbook

I have 2 sheets inside the excel file i just want to link different sheet using url in different page is there any way that i can open the specific sheet of excel file using the url in the browser i ...
0
votes
1answer
798 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 ...