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

learn more… | top users | synonyms

1
vote
0answers
41 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 ...
1
vote
0answers
128 views

“Open in Excel” prompt disabled when accessing workbook through office web apps

We're trying to share an excel workbook through SharePoint which sends a link through mail with "web=1" which calls for excel web access. since the document has unsupported features in OWA, it prompts ...
1
vote
0answers
72 views

Unsupported features: Display of formulas in cells

I have a number of Excel templates that are stored in SharePoint library. When trying to either view or edit the files in my browser, I get the error message that the browser can't be used because ...
0
votes
0answers
77 views

Insert SharePoint metadata into excel cell

What is the best way to create a system that inserts metadata fields of the document in SharePoint in a cell in Excel? I've done this behaviour multiple times in a Word document using the 'Quick ...
0
votes
1answer
70 views

Quick edit List URL field

I need to use the quick edit on a Link List (I am copying data from an Excel file). I am having trouble with the URL field, I can easly insert the URL but I don not know how to insert the URL name. ...
0
votes
1answer
204 views

How to get excel file from sharepoint library and write to it programmatically

we would like to read an Excel template stored in a SharePoint 2010 library create a new Excel file from it fill the new Excel file with data programmatically we tried already Excel Services but ...
2
votes
7answers
13k 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 ...
0
votes
1answer
29 views

How can I know what was modified in an Excel file hosted on a SharePoint site?

Currently, I have an alert set up so that if someone modifies an Excel file I receive an e-mail. It works fine. However, I can I tell what was modified when I go back to check on the file?
2
votes
1answer
40 views

How can I see what has changed in an excel file that is posted on SharePoint?

I currently have an Excel file posted on SharePoint 2007 with an alert set up to tell me when it is modified. It works fine, but my question is how can I tell what has changed when I go to review it?
0
votes
0answers
96 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 ...
1
vote
0answers
28 views

Is it possible to filter chart without refresh?

I have created a chart in excel using PowerPivot and I am using oData Data Feed to get values from my SharePoint List. I have set auto refresh at every 60 minutes and I have used some filters also. I ...
0
votes
0answers
70 views

Excel file which have macro enable not opening in IE

I've a requirement in which an excel file( Macro Enabled) is stored in SharePoint 2010 and when user clicks the file, it should open in the IE as read only file. The Excel file is opening in the IE ...
0
votes
0answers
53 views

Sharepoint list 2010 connecting to excel refresh data

I've managed to export all the files to Excel and upload it to Sharepoint location. This Excel file is used as table of content of all documents that we have in our company. I've also managed to set ...
1
vote
1answer
883 views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
0
votes
0answers
105 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...
0
votes
0answers
12 views

Excel slicers change height on Sharepoint

I've got a report that I publish on a Sharepoint site. When it's on my machine the slicer "size" "height" is set to 1.52". Once I load it to the Sharepoit site and someone opens it and edits it in ...
0
votes
0answers
26 views

HTML tag rotation only rotates dimensions but not text within

I saved an Excel sheet as an HTML file and I needed the header text to rotate 270 degrees. I made it work on all browsers while I edited and tested only as an independent HTML file, but when I added ...
1
vote
1answer
57 views

Sharepoint List & Export to excel sheet

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ? If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and ...
3
votes
1answer
26 views

Reusable Tasks - moving an process from excel workbooks to SharePoint

My team use a SharePoint 2013 team site. Currently when we deliver training we use an excel workbook which tracks student names, and tracks their scores and has a standard task list of content that ...
0
votes
0answers
50 views

Excel web part not working in Chrome when navigating back to page

I have a page that is using Excel web parts that has links to documents that they can view. When they navigate back from the document the excel web parts aren't loading. This is only happening in ...
0
votes
0answers
18 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
194 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 ...
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
0answers
45 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
112 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
30k 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
147 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
123 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
73 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
21 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
16 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
490 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
39 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
2k 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 ...
0
votes
1answer
70 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
93 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
34 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
34 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
42 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
3k 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
2k 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
45 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
177 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 ...