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

learn more… | top users | synonyms

0
votes
0answers
17 views

Get the email of logged in user in Excel on SharePoint?

Get the email of logged in user in Excel on SharePoint? Since VBA doesn't run in O365 does anyone know a way to get email? I am trying to do reporting based off of email so a user only sees data in ...
3
votes
3answers
6k 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.
1
vote
1answer
152 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 ...
1
vote
1answer
292 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" - ...
0
votes
1answer
15 views

Caluclated Field/Formula: Automated Month Counter

I have a "Start Date" field and a "Months in Process" field. Upon changing the start date, I need the "Months in Process" field to start ticking from 0 and increase in increments of 1 month. Everytime ...
0
votes
1answer
300 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, ...
0
votes
0answers
37 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: ...
0
votes
1answer
85 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 ...
2
votes
4answers
26k 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, ...
0
votes
0answers
19 views

SharePoint Portal

I am completely new to the SharePoint development environment, though I have experience in VBA. I am attempting to create a SharePoint site that will allow several vendors to view an Excel ...
4
votes
2answers
2k views

Run an Excel Macros from SharePoint

I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
0
votes
1answer
119 views

Linking an Excel document to a List

I have an excel document which is sent daily to me. I have a SharePoint List that is then update daily by me with all the excel documents information (complete overwrite each day). The list is used ...
2
votes
1answer
103 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 ...
0
votes
0answers
10 views

Excel Web Part: add a chart with an ambiguous name

I have an excel file with a bunch of macro-generated charts in it. The charts span across different sheets, and when the macro runs to generate them, they get different names every time. I want to ...
0
votes
0answers
64 views

Export to Excel is slow

I am working with SharePoint 2010 / 2013. Very often I have to export large lists (>1000 Items) to Excel. This always takes some time (e.g. about 3 Minutes for 3500 list items). Is this normal, or ...
0
votes
0answers
20 views

SharePoint Designer 2013 and Excel issue

I have custom Excel addins which were getting loaded and working (in Excel 2007,2010) before installing MS SharePoint Designer 2013. After installing it the addin is always getting the LoadBehaviour ...
0
votes
0answers
15 views

Loss of formulas when using excel to move sharepoint lists

I need to move a list in Sharepoint 2010 from one site to another. I have tried doing this by (1) saving original list as an excel worksheet and (2) creating a new list from that worksheet. The ...
0
votes
1answer
328 views

SharePoint List View - Export to Excel with Formatting and Grouping

I have a SPList View with 2 levels of grouping. First level is Company and the second level is 'Month - Year' which is a calculated field. Below is the view's screen shot: The issue is when a do ...
1
vote
3answers
7k 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 ...
0
votes
0answers
35 views

Generate ppt slides from Sharepoint data

There is a form in SharePoint and I need to generate an one page Powerpoint slide using some data from that Sharepoint list. I'm thinking about creating a template in Powerpoint. Let's say there will ...
3
votes
2answers
1k views

We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Interactive report sheets

I use SharePoint 2013 and Power Pivot Services. I create a Excel report with Power Pivot and I fetch data from my Data Warehouse. I upload this Excel file in SharePoint Documents. For update my ...
1
vote
3answers
2k views
0
votes
1answer
61 views

Is permission level affecting Excel links from updating?

I have some Excel documents on a Sharepoint site. I added some links to other Excel documents on a network drive. When I open the Excel files on the Sharepoint directory, they update just fine. ...
0
votes
0answers
87 views

How to get list data to Excel to create chart with date filter?

I have to create chart from a custom list in o365 site. There is one column named "Due Date" in my list. I want only those records whose Due Date is today or gone, I mean Due Date <= Today. How ...
0
votes
0answers
32 views

Cannot connect to server Excel file

I have a user in my company's portal (SharePoint 2007) that cannot upload changes made in an Excel file. He needs to have the compatibility view active in IE in order to be able to open the ...
1
vote
2answers
1k views

Export SharePoint Search Results and List View to Excel

Can we export SharePoint Search Result to Excel? Note that our client is using SharePoint Foundation 2010. I have searched the web and found a free tool that does this but unfortunately it works only ...
2
votes
3answers
7k 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 ...
0
votes
0answers
33 views

Show User List in Cell Value of Excel App

I had created an app using Import Excel SpreadSheet. I have one column named as "User" in the list. I want whenever any user add the record in the list, for "User" column it should show list of ...
0
votes
0answers
40 views

Excel web app 2013 title field disapearing

We have a document library that users will be using office web apps to edit. When using Word or PowerPoint, everything works fine. When they use Excel, it gets weird. When they edit a document, ...
4
votes
3answers
2k views

Filtered SharePoint List for Export to Excel

I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then ...
0
votes
1answer
1k views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
0
votes
1answer
43 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
0answers
173 views

This workbook was opened from a server in read-only mode

I'm double clicking an odc file stored in the connections library of a SP site. When the workbook opens I get the following: The error window pops up when I hit Edit Workbook - can anyone shed any ...
0
votes
1answer
105 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
0answers
36 views

'Invalid signature' in Excel 2007 when trying to open an Excel file

In SharePoint 2010, I'm trying to open an Excel 2007 document, there I get following error: "Invalid Signature". Still the certificate of the user is valid.
0
votes
1answer
72 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
1
vote
1answer
110 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 ...
0
votes
0answers
139 views

Excel error: Cannot connect to the SharePoint list

I am trying to export some data from external list to Excel 2010 and the error is: Cannot connect to the SharePoint list (My SharePoint Server is 2013). However when I do that within Excel ...
4
votes
2answers
913 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
0
votes
0answers
22 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
1
vote
1answer
61 views

Read excel data from attachment and display in SharePoint and allowed to edit

User would like to upload a excel file into SharePoint and he expect system to read his file and display out the data that he have uploaded in SharePoint. Besides, from SharePoint, he requested to ...
0
votes
0answers
18 views

Linking to sheet number 2 on an embedded Excel Web Access

I want to link to one of my sheets in an embedded spreadsheet (using Excel Web Access) from another page - is this possible?
0
votes
1answer
217 views

Excel Online - Enter Array Formula

In Microsoft Excel entering an array formula requires using the keyboard combination: Ctrl Shift Enter How can I enter an array formula in Excel Online (the WebApp version of Excel). Is there ...
0
votes
3answers
425 views

Can we create Excel file using c#?

I would like to know if it is a good idea to create an excel file using c# in sharepoint? I've tried to find js libraries but despite ExcelBuilder which seems really complicated to use i can't find ...
1
vote
0answers
1k views

Unable to check-out an excel sheet from a document library in SharePoint 2010 Standard

I have a document library under my SharePoint 2010 Standard site. We are uploading Excel files to this document library to be updated by multiple users (Using Check-in/Check-out). We are using IE9 as ...
0
votes
1answer
68 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
1answer
176 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 ...
0
votes
0answers
37 views

save excel spreadsheet to cs to sharepoint server

I am trying to save an Excel spreadsheet to .csv to a SharePoint server but running into issues Within an Excel document, I go to: File > Save As > change the file ‘save as type’ to csv (comma ...
0
votes
1answer
114 views

Filling SharePoint Calendar List With Bulk Data(About 3000 Entries)

I want to fill about 3000 entries in a SharePoint calendar List for testing purpose. I have tried using this link but i have some lookup columns and person/group fields which do not appear in the ...
0
votes
0answers
316 views

Excel Online - refresh data in a SharePoint list

I have added a SharePoint list to an excel spreadsheet as an odata feed. This data connection refreshes perfectly using Excel on the Desktop. However, when I refresh the connection in the Excel web ...