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

learn more… | top users | synonyms

0
votes
0answers
26 views

how to stop DATEDIF function when employee is terminated

I'm using the DATEDIF function to Calculate the time an employee has been employed. I'm using =DATEDIF(G25,TODAY(),"y") But what I want to do is to stop calculating the time when an employee is ...
0
votes
0answers
93 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
1
vote
1answer
293 views

Sharepoint Excel data table and Chart

Need help about sharepoint. I have a table data collection currently in ms excel document look like the following image. every last day of the week the information will be updated (append new ...
0
votes
1answer
1k views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
0
votes
2answers
185 views

Error when I fill in metadata in excelsheet Document Information Panel

I am using sharepoint 2010. I have a document library with a contenttype. I have some word, excel and pdf documents inside of it. When I open an existing excel sheet and go to the Document Information ...
0
votes
0answers
15 views

refreshing a query in Excel from a list of Sharepoint

When I have added more records to a list on SharePoint and I run "refresh query" in Excel, I don't see the added records in Excel. Looking at the table the range of it can not be extended, for the ...
0
votes
0answers
149 views

excel macro to vlookup sharepoint list

I am trying to create a macro that looks up data (vlookup) from a SharePoint list. Once done, I want all the contents in my excel file to replace those in the SharePoint list. I can do all this from ...
1
vote
3answers
405 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
0answers
12 views

Disabling copy/past in Excel Web App

Is there a way to prevent a user copying and pasting cells from online version of excel - either excel web services or web app?
0
votes
1answer
8k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
0answers
137 views

How to insert new records on an sharepoint list from EXCEL VBA

I have an worksheet with the code below and I wanna populate a SharePoint list with it, but the code returns me the error: It isn't possible update the changes while there is validation errors in ...
0
votes
1answer
27 views

Can I extract a list with a button in infopath 2010?

I'm working on sharepoint 2010. I want to know if it's possible to create a button which extract the list the infopath is based on in an excel sheet. Thanks.
0
votes
0answers
51 views

Opening older Office files in SharePoint 2013

We have an external SharePoint site set up using version 2013. We have saved Word documents and Excel spreadsheets in older formats such as Office 2003. The reason for this is that customers ...
3
votes
1answer
13k 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 ...
0
votes
1answer
298 views

Unable to update an excel file in SP

One of our users is currently trying to update an excel file that is saved directly to our SP document library. Whenever he tries to update it and save it the changes for some reason never save. It ...
0
votes
1answer
81 views

Updating excel information to a list matching a custom ID column

I'm on SharePoint 2010. An excel file is uploaded to a document library.This excel file has a custom ID column(alphanumeric) and many more columns. There is a list which contains many columns along ...
7
votes
2answers
6k views

Adding document version number on Excel Spreadsheet as label for printing purpose

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document. I ...
0
votes
0answers
27 views

how to change the headers of a list exported to excel?

I want to use the sharepoint 2013 feature exporting to excel from a list but I want to change the name of the fields, how can it be done?
3
votes
0answers
5k 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 ...
1
vote
0answers
68 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
223 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
139 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
120 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
152 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
409 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
14k 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
41 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
64 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?
1
vote
0answers
44 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
86 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
2k 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 ...
1
vote
0answers
162 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
14 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
31 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
115 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
29 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
64 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
21 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
8k 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
393 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
19 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 ...
1
vote
0answers
73 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
369 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 ...
4
votes
2answers
3k 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
305 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
231 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 ...
1
vote
0answers
143 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
1answer
1k 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 ...
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
123 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. ...