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

learn more… | top users | synonyms

0
votes
0answers
32 views

Cannot Copy and Paste in SharePoint 2007 datasheet view

I currently have office 2013 and I have been copy and pasting into a datasheet view list for SharePoint 2007 for a long time. All of a sudden I cannot paste any values into my list. the load wheel ...
0
votes
0answers
151 views

How to get the Last Modified Date and Time of an Excel file in a Sharepoint using VBA?

i am creating a macro file with command buttons that when you click it, it will display the properties esp the last modified date and time of an Excel file uploaded in a SharePoint site. How can i do ...
0
votes
1answer
657 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 functionnality, it also exports two columns called "Item Type" and "Path". Is there a way OOTB or programatically to exclude these columns ...
0
votes
1answer
21 views

Limit users to their own employees

I have a list of about 1000 employees with their addresses and phone numbers which I want to upload to a 2007 SharePoint in list format, which I know how to do, however due to data protection, ...
0
votes
0answers
188 views

Creating a file via VBA leads to Check-in Stalemate

We have Sharepoint 2010 Enterprise. I want to create a series of workbooks for salespeople, each one personalized, and with a different name . I want to have check-out enabled on the target doc ...
0
votes
0answers
48 views

problem with exporting sharepoint 2007 list to excel spreadsheet

I have a user who wants to be able to export data from a document library to a spreadsheet. This should be a simple matter of clicking the actions menu and selecting 'Export to Spreadsheet' and when I ...
0
votes
2answers
1k views

How to import MS Excel data into an exisiting SharePoint List?

Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but ...
0
votes
0answers
90 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
0
votes
0answers
474 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
46 views

Excel Cell Link to InfoPath sending data to SharePoint

I want to be able to send out an Excel file with a list of clients and use that file to be able to open up a form when they click on a client. The form would be pre-populated with information from ...
0
votes
2answers
77 views

Show SharePoint columns in Excel sheet

How can one show columns from a SharePoint document library into an Excel sheet. Properly with VBA, but I don't now how?
0
votes
1answer
17 views

ExcelWebPart Issue

I'm using ExcelWebpart in my page and I defined permissions on the webpart. Some users can edit the excel webpart. They click "OPEN IN EXCEL" and then they can edit. But today when they click on the ...
0
votes
0answers
33 views

Syncing Sharepoint 2013 List from Excel 2010 spreadsheet?

So i'm trying to figure out a way in which I can append items within my SharePoint list by inserting the data from an Excel Spreadsheet. However, the SharePoint list has additional columns which are ...
0
votes
0answers
34 views

SharePoint 2013 online List export to excel with views as worksheets

I have a client that would like to export a SharePoint List to Excel but to also include the views as the worksheets. How would I go about implementing this? Is this even possible? The data would ...
0
votes
0answers
85 views

Error when trying to reference an excel sheet inside SharePoint document library “The file name, directory name or volume label syntax is incorrect”

I have the following :- SharePoint document library. Inside the document library i have; Visio diagrams + excel sheet. now i am using an Add-in inside the Visio drawings to reference the Excel sheet ...
0
votes
1answer
10 views

Convert Sharepoint webpart 2013 to 32 bit version

Are there any ways to convert the visual webpart to 32 bit version. I have target in the property project c#, but I couldn't add the webpart to page. What I meant is in my case: I open excel file by ...
0
votes
1answer
349 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 ...
0
votes
1answer
374 views

Open a link of Excel with the dialog popup window in quick launch SharePoint 2010

I have a Excel document in the Library SharePoint 2010. And I set "Open in the client application" in Library setting. Every time I open this document, there is a popup window with a question "How ...
0
votes
0answers
13 views

Excel Services Problem

one of our client was adding Excel access webpart to his site and when he clicked on Edit webpart properties, he is not able to see all the properties of Excel access webpart which he should see. When ...
0
votes
0answers
89 views

“Open In Excel” button inside the Xlviewer.aspx page return Error and I can not open excel using local office

Inside the xlviewer.aspx page of sharepoint 2013 when I click on "Open In Excel" at first I receive this Error: Some files contain viruses that can be harmful to your computer. it is important to be ...
0
votes
0answers
35 views

Give Permissions to the Excel WebPart

I created a new webpart page with ExcelWebRenderer. I want to give edit permission to a group for the excel page. Other persons have read only permission for this excel page. I created a group and I ...
0
votes
0answers
12 views

Copying part of Excel workbook to a different workbook in SharePoint 2010

I have a rather simple task, at least by the description. Let’s say I have a File A (xslb) on SharePoint A and I need to copy out some data from File A to File B. File B is xslx document on a ...
0
votes
0answers
29 views

How to export SharePoint 2007 AD Accounts to Excel

Is there any way to export SharePoint 2007 AD accounts to Excel? I know that there are couple of ways to export SharePoint Userinfo list to Excel. But i want to export SharePoint 2007 Active Directory ...
0
votes
1answer
25 views

Display a Excel Chart

I'm using sharepoint for my team, and i would like to dispalay charts which update daily from my data connections. Currently i use a images and update daily, i want to automate this by hosing the ...
0
votes
1answer
1k views

Getting fully qualified FieldUserValue instead of actual user name from SharePoint

I'm working on my first C# program, and it's a pretty simple program that uses a view of a SharePoint page to go through and delete things that are older than 5 days on that page. Before deleting the ...
0
votes
1answer
94 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
0answers
35 views

when user chooses Edit in Excel the spreadsheet just hangs trying to open

A user has complained that when they try to open an Excel spreadsheet on SharePoint by choosing 'Edit Workbook' then 'Edit in Excel' it tries to open but just hangs. This happens for any Excel ...
0
votes
0answers
75 views

Export data from excel to sharepoint list through a form

Is it possible to export data to sharepoint list from excel using vba macros. The list is populated through a form which has combination of check boxes, drop downs and text boxes and you have to press ...
0
votes
0answers
50 views

SharePoint 2013 - Excel SUMIF between to Excel files

In our system are since two weeks some Excel files where a connection between the files was made with the "SUMIF" function. the problem is that the user wants to update the data in the 2nd file (which ...
0
votes
0answers
85 views

Open html exported from Excel as a webpage

I've been troubleshooting this one for a while now. SharePoint 2013 is opening my htm/html files that I export from Excel as an Excel Worksheet. I want the htm/html files to just open as a html ...
0
votes
0answers
172 views

Sync Excel and SharePoint List

Has anyone ever done this successfully using Excel 2010 ? I downloaded the Add-in (SynchronizeWSSandExcel: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=9345 ) but it's ...
0
votes
0answers
28 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
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
158 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 ...
0
votes
0answers
97 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 ...
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
0answers
143 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
28 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
56 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 ...
0
votes
1answer
349 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
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?
0
votes
1answer
168 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
42 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?
0
votes
1answer
282 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 ...
0
votes
1answer
105 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
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 ...
0
votes
1answer
390 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
2k views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
0
votes
1answer
83 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 ...
0
votes
1answer
128 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. ...