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

learn more… | top users | synonyms

0
votes
1answer
22 views

SharePoint 2013: Excel Import Issue

I'm importing an excel list with many columns, but one of the columns is unable to be used in a lookup table. The column contains the multiple owners for the main object and sharepoint can't read it ...
1
vote
2answers
31 views

Export all lists to excel

I have three different list seperated by Area (NY, NJ, and CT) is there a way to build a report in the database that will pull all records from all lists? I exported all three to excel one by one, but ...
4
votes
1answer
2k views

“Check Out” button not appearing in Excel 2010

One of my coworkers has this problem for some of the files stored in a document library. If he clicks on the link, from the document library, the dialog has these two options: "Read-only" and "Edit" - ...
3
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 ...
3
votes
2answers
1k views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
1
vote
3answers
2k views

create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013?

I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content ...
1
vote
1answer
618 views

Prevent User saving excel document back to Sharepoint

I have users on Excel 2010 and they are accessing a sharepoint site using Sharepoint Services 3.0 and clicking on the excel document and the default behaviour is to save this back to sharepoint rather ...
1
vote
1answer
698 views

Which Excel functions are not supported by SharePoint calculated columns?

This MSDN article lists various functions that can be used in SharePoint calculated columns, and also includes the following disclaimer: Note Microsoft SharePoint Foundation formulas ...
0
votes
1answer
770 views

Exporting discussion board with all the replies

Is there any way to export a discussion board to Excel with all the replies? I've tried clicking on Export to Excel from the ribbon, but what I get isn't what I want as this does not give me the ...
3
votes
1answer
20 views

Way to Preserve Links when Moving Excel files from File Share to SharePoint?

Is there a way to preserve the links that connect Excel files that are stored on a file share but are moving to SharePoint?
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 ...
1
vote
2answers
67 views

Fetch lookup column data in excel using ODATA Feed from SharePoint List

I am trying to fetch a data from SharePoint list to excel. Lookup column with multiple choice (person and group field) is not getting populated in the excel. Can anyone help me with this. Below is my ...
1
vote
1answer
614 views

Sharepoint Excel Error IE9 - Workbook is larger than the maximum workbook size allowed to be opened in the browser

A few of my users who are using ie9 for a sharepoint housing a few excel files around 19mb are experiencing a recent issue where they cannot see 'read only or edit' options; (this is enabled to open ...
0
votes
0answers
18 views

Opening office document from trusted site require authorization twice

My web application has two Site Collections, https://my.server/ and https://my.server/sites/mysite. When I open a excel document in second one /sites/mysite, the excel app is launched and log in ...
0
votes
2answers
10k views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
0
votes
1answer
1k views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
10
votes
7answers
51k 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 ...
1
vote
1answer
6k 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 ...
0
votes
0answers
17 views

How Can I pass EffectiveUserName to SSAS through Excel Service using FBA(Forms based authentication) in SharePoint 2013

We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube. Our Authentication method to login ...
1
vote
1answer
19 views

Excel 2016 can't find SharePoint users in metadata field

I'm developing on SharePoint, but this rather seems to be Office question, so I ask this question in this forum. In Office 2013 there was nice metadata bar, where you could fill different values, now ...
1
vote
1answer
19 views

Sharepoint re-ordering list

I've got a SharePoint Calendar that i've linked to an Excel document and it's currently pulling the data through and dumping it in a table and also a chart on another sheet (But that's irrelevant!) ...
0
votes
0answers
23 views

Locked Task Solution. Did I break it?

enter code hereI'm a site collection admin. My organization uses Sharepoint-online. We've been plagued by the "This task is currently locked by a running workflow..." messages. It's really crippling, ...
1
vote
1answer
21 views

Excel Reporting linked to SharePoint

I'm currently having some issues linking Excel to my online calendar (list) whenever I choose the web as a data source and I enter the URL of the calendar I get the option to only import the entire ...
1
vote
1answer
994 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 ...
0
votes
0answers
9 views

COUNTIFS function in SharePoint List

I have challenged myself to create a list where a list or library's columns and data are exported automatically into a Excel Workbook or web-part, then evaluated via COUNTIFS to read multiple columns ...
3
votes
1answer
60 views

Open new item direct with excel

I am using O365 SharePoint and Create a WebPartContentType with an Excel-Template. So when you click on "New Item" it open the Template with Excel-Online. Now my question: Is it possible to open the ...
2
votes
1answer
697 views

Export to Excel for sharepoint 2010

Export to Excel was previously not working for clients that were using Office 2007 because we are using claims-based authentication. A few days ago, a few clients noticed that the export to Excel ...
0
votes
1answer
823 views

Cannot upload macro excel file

I have a problem with uploading macro (xlsm) files in a SharePoint Foundation 2013 Site collection. Strange is that on other SharePoint site collections which are on separate server farms, it works ...
0
votes
3answers
63 views

Are there list view url parameters to export to Excel?

I would like to automatically export a list view to Excel as a single click process. Are there parameters I can add to the list view url that will accomplish this? The list view is currently provided ...
2
votes
2answers
153 views

Use a workflow to filter a list

I have a spreadsheet that contains numerous products, each one with a unique PN, desc and price. There is similarity between products, contained in additional columns with simple YES or NO values ...
0
votes
1answer
2k views

Export SharePoint list to Excel - How remove column Item Type and Path

When I export a SharePoint list to Excel using the built-in functionality, it also exports two columns called Item Type and Path. Is there a way OOTB or programatically to exclude these columns from ...
0
votes
1answer
1k views

Excel Linked Cells

I have the following use case: Two Excel documents are stored in the same folder on a shared drive (a typical SMB Share). The workbooks are linked through a single linked cell. If you open both ...
1
vote
2answers
62 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....
0
votes
1answer
960 views

How to avoid authentication prompt when opening XLSX document on anonymous site?

I have a SharePoint 2013 that is setup in anonymous mode (at the web app level and then at the site level; the Entire Web site is being exposed as anonymous). I then have the "lock-down mode" feature ...
0
votes
1answer
125 views

Anonymous Users cannot open XLSX/PPTX files from a SharePoint 2010 document library

Scenario :- Environment :- SharePoint 2010 we have a Site Collection and sub-site which has complete Anonymous Access and all the Document Libraries under the sub-site are given View Items ...
0
votes
0answers
18 views

Missing columns when extracting list via VBA

I'm trying to extract a list from a corporate Sharepoint using VBA, but a key column does not get extracted. When I Export to Excel from Sharepoint, the column does get extracted. But I want to be ...
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 ...
1
vote
1answer
40 views

Can SharePoint view in browser docx/pptx/xlsx taken from external sources?

I've noticed SharePoint project (2013 atleast) can view in browser Excel, PowerPoint, and Word document files, which is great. So when you create an html5 web app on SharePoint, you can link the docx/...
4
votes
2answers
4k 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 ...
0
votes
2answers
641 views

Excel document opening in web view even though default is to open in program

I have a document library with one Excel spreadsheet in it. The document library's settings are such that the spreadsheet should be opening in each client's Excel program, not in Excel Web View. I ...
0
votes
2answers
21 views

Hyperlinks in Excel are changing when uploading to SharePoint document library

I uploaded Excel files from an external drive to SharePoint document library. The hyperlinks in the Excel spreadsheet works fine in my local, I can open the links. However, when I uploaded it in ...
0
votes
1answer
11 views

Customized Write Protection of Excel Forms on SharePoint

I have excel files on a SharePoint site which I am linking to the company's intranet. The reason we have the forms on SharePoint is that certain people need to update the forms regularly and we want ...
3
votes
2answers
9k 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
4answers
54k 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 ...
0
votes
1answer
27 views

User issues when opening the owssvr Exporting a List to Excel

I have created a List and Exported that list to Excel via owssvr. I have one User in our 15 person group that when she opens the owssver. One of the columns is supposed to show Last Name, First Name. ...
0
votes
1answer
718 views

Search excel spreadsheet or Microsoft access within sharepoint

I have a spreadsheet with a list of batch jobs. I was wondering if it's possible to create some type of search into a sharepoint to search this spreadsheet. We are using sharepoint and if I could have ...
0
votes
0answers
7 views

Excel Online Office Add-In as a Service

In Google Sheets, using Apps Scripts, we can have a spreadsheet run as a service. We can write doGet and doPost methods in Apps Script which allow to handle HTTP Requests. Is this possible in Excel ...
0
votes
0answers
7 views

Excel Embeded View Editable fields?

I know how to embed excel on page so that users can see the data. I want users to be able to input updates on the page excel embed rather than opening the excel file. Is it possible?
0
votes
0answers
28 views

SharePoint App - How to Create/Populate Excel Spreadsheet Using JavaScript and List Data

I'm trying to create a Excel spreadsheet on a SharePoint app/add-in. The data that will populate it have been gathered from several SharePoint lists on the host web. Right now, I'm able to interact ...
0
votes
1answer
37 views

Hyperlink to Excel file in SharePoint Online: How to set by default that file opens in Excel (not Excel Online)?

I have put a hyperlink to an Excel file in our SharePoint (Online) to my company's intranet. How can I manage the file opens by default in Excel, not in Excel Online? Excel Online does not support ...