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

learn more… | top users | synonyms

2
votes
2answers
637 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 ...
2
votes
2answers
4k 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 ...
0
votes
1answer
17 views

Import interactable Excel document

Is there a way to import an Excel document to a sharepoint list that is intereactable just as it would be in Excel? I've tried but the functions wouldn't follow with the list to sharepoint, only the ...
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 ...
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 ...
1
vote
1answer
634 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
2answers
26 views

Track SharePoint Changes

I have made a view in my SharePoint from an excel file and want to track the daily/weekly changes. How could I set up something to send out an email weekly to notate what changes were made and what ...
0
votes
0answers
8 views

SharePoint 2013 and Excel 2010 - This workbook was opened from a server in read-only mode

Users are getting the error as " When users click on Edit, they get the following error: Users cant edit the spreadsheet. I already checked the permissions and permissions are fine. I already ...
1
vote
1answer
7k 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 ...
1
vote
2answers
29 views

Unable to Export to Excel

I am attempting to export a list of files and their metadata into excel 2010 via internet explorer, the file is created and appears to download normally but when opening the excel window it freezes ...
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
0answers
13 views

Live chart using SharePoint Excel Webpart

I have a list on SharePoint online. What I am doing right now is, exporting the list data into an excel file. And then created some charts in that file. To display the charts on a sharepoint page, I ...
0
votes
0answers
8 views

SharePoint to Excel Formula Deletion

I keep having an issue when I open a document that pulls data from a SharePoint site. Once I refresh the connection in excel, the formula that I have inputted into a column in excel disappears? Anyway ...
1
vote
1answer
21 views

SharePoint Date Formula

Let's say you have a date formatted as 31/Dec/16 but wanted to calculate two cells over to show 201612. How would I put in this formula because excel and sharepoint do not have it already formatted in ...
0
votes
1answer
11 views

Configuring Co-Authoring in SharePoint 2013 site collection?

How do I configure Configuring Co-Authoring for SharePoint 2013 site collection for MS Word or Excel documents?
0
votes
0answers
6 views

Sharepoint removing Excel text boxes

I have a number of Excel workbooks with text boxes that I place into Sharepoint folders. When downloading those files from Sharepoint the text boxes have been removed. Is there something I can do to ...
0
votes
2answers
729 views

Connect SharePoint Lists with OData

I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list ...
1
vote
1answer
1k views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
2
votes
1answer
701 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
0answers
11 views

How to open a Excel file containing macros in Browser? Also Allow users to co-author the excel file

How to open a Excel file containing macros in Browser from sharePoint document library? Also Allow users to co-author the excel file
0
votes
2answers
657 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 ...
1
vote
1answer
1k 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
1answer
17 views

Is it possible to use a custom .xlsm file as the template for a document library?

I have a macro enabled Excel spreadsheet (.xlsm) that I want to use as a template for a form library. I want to know whether it is possible to do so? If not, is there any other way I can make all the ...
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
1answer
892 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 ...
1
vote
0answers
22 views

Person lookup in Excel metadata field crashes

I have SharePoint 2013 Foundation and I open Excel 2013 from Document Library, which has serval metadata fields, including Person Lookup. Now, when I press Address book icon at Excel metadata bar, ...
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 ...
5
votes
2answers
3k views

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

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 is as follows: "We can't do that because the ...
0
votes
1answer
988 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
736 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
1answer
31 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
36 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
3k 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
756 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
797 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
25 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
85 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 ...
0
votes
0answers
19 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 ...
10
votes
7answers
52k 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 ...
0
votes
0answers
24 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
20 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
24 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
22 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 ...
0
votes
0answers
10 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
63 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 ...