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

learn more… | top users | synonyms

1
vote
1answer
16 views

Automaticly update connected excel file when a new item is added to a sharepoint list

I have a sharepoint list that we update daily and it is connected to an excel file that we update manualy. So what I would like is when a new item is added to the list it automatically updates the ...
1
vote
1answer
2k views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
0
votes
1answer
3k 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
1answer
22 views

Using SP.FileCreationInfo to modify an .xlsx or .xls file

I'm trying to create a client-side solution where customers can download a template .xlsx document populated with data filtered from a SharePoint list. I know that JavaScript generally isn't used to ...
0
votes
0answers
4 views

Embed data sheet view of a list on a application page

I have a requirement where I need to show a data sheet view on a application page. Basically I have replaced the newform.aspx with a application page. This application page displays data from another ...
1
vote
0answers
5 views

Workbook.CheckIn always produces an error the first time it's called? (x-posted on StackOverflow)

This question is cross-posted on SO here. I have some workbooks stored in a document library on Sharepoint 2007. I want to check out a workbook, modify it, and check it back in. Using the following ...
0
votes
1answer
82 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
16 views

How to export to excel only items filtered on my view

In my specific list, I filtered to a account we are going to pay. Then when I click on "Export to Excel" button all the items of the list gets exported. How would I export data that I want? ...
1
vote
1answer
689 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
0answers
11 views

Office 365 for Mac(Yosemite) SharePoint won't open file in Excel.

File xlsx uploaded to SharePoint won't open using the Edit in Excel button. It appears to start, but not finish. Excel does not include this file in 'recent files', so cannot be opened from Excel. ...
0
votes
2answers
3k 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 ...
0
votes
1answer
15 views

Can I apply check out rules to a single document in a document library and not the whole library?

Is it possible to apply check in/out rules to a single document in a document library without applying the same rules across the document library via the Library "Version Settings" section?
1
vote
1answer
656 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
2answers
16 views

Connection to SharePoint list on SP 2010/13 STANDARD Edition

My organisation will downgrade from SharePoint 2010 Enterprise Edition to SharePoint 2013 Standard edition. I am not part of the decision making, but I heard the decision relates to cost or licensing. ...
0
votes
1answer
645 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 ...
2
votes
1answer
48 views

Can I edit a workbook using Excel Services?

I created a web part putting my Excel worksheet on one of my Document Library, so I can have the live view of that worksheet without opening it again and again, my question is, can I edit that ...
2
votes
1answer
1k views

Can't open excel file in edit mode, currently open by 256 users

I got an issue from one of my users, where he would get the following message whenever he opened a particular excel file stored in a document library. The workbook is currently open by 256 users. ...
0
votes
2answers
45 views

Creating Excel document using JavaScript

I've been researching into creating Excel documents in a SharePoint Library from an existing Excel template but all solutions I find are using server code. The Template can be part of a CT or in ...
1
vote
1answer
17 views

Cannot find (Excel Services Application & Visio Graphics Service ) inside the Service Application Menu

I have installed a new SharePoint server , and I wanted to create a new Visio graphics service and Excel service application, so that users can view excel & Visio documents inside their web ...
1
vote
1answer
636 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
0answers
24 views

Excel 2013 Not Saving To SharePoint 2010 Library

I've got a peculiar problem with a couple of users having issues saving back their Excel document to their Document Library. As it is now, they'll have issues when they open the document from ...
3
votes
1answer
552 views

Saving an Excel file: You do not have the correct permissions. Contact the server administrator

A user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
1
vote
1answer
455 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" ...
0
votes
0answers
20 views

Auto refresh Odata connection between SharePoint list and MS Excel

I have an Odata connection set up in Excel Services to SharePoint list data. The Odata connection pivots the list data, then charts it in Excel Services, and the chart is hosted in SharePoint When I ...
0
votes
0answers
14 views

Problem with Excel View and Calculated Column

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...
0
votes
1answer
699 views

Automatically Import Excel Data to SharePoint List

This question has been asked before but I haven't found an answer that works for me and my limitations. I have an excel spreadsheet that is currently being used to input data with 20+ records each ...
0
votes
2answers
34 views

List Items Export to Excel on SharePoint 2013

I have a list on SharePoint 2013 and I want to export the list items to excel file. How can I do export process?
0
votes
1answer
1k 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
2answers
942 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
53 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
2answers
50 views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
0
votes
2answers
37 views

Pasting excel rich text column into Sharepoint 2013 list edit view

I was trying to paste an excel table to SP2013 datasheet view with one of the column is enhanced rich text editor. But the view stripped out the styling from excel table. Excel table: This is the ...
1
vote
4answers
8k 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 ...
3
votes
5answers
40k 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
10 views

Export to Excel does not export columns with multiple selections in SharePoint 2013

I am trying to export a list to Excel (Office 2013) that contains columns containing multiple selections, except the columns with multiple selections are completely missing from the exported Excel. To ...
0
votes
0answers
21 views

Excel Connect to SharePoint Online Document Library

We have a number of people in the field who fill out fairly complex evaluation forms in excel. These forms are submitted to a document library in SharePoint Online What I need to be able to do is ...
0
votes
0answers
9 views

excel file uplodaded in sharepoint 2013 document library not opening

I have a document library in sharepoint where excel files are uploaded. But when we click on the excel file we are not able to view it. It give me the following error. Microsoft Office Excel cannot ...
1
vote
1answer
28 views

Excel Access Web Part changing my Top Navigation Bar

I am a newbie on this site. I am NOT a SharePoint developer or admin by trade. I have accumulated this job with on the job training. I am by far not an expert or claim to be. My issue is this, when I ...
3
votes
2answers
3k 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 ...
1
vote
1answer
41 views

Sharepoint Excel Dynamic dashboard according to a list

I've a list which has something like this: List Title Status Title 1 Active Title 2 Pending Title 3 Active Title 4 Closed I need an Excel BI dashboard which should be dynamically ...
0
votes
0answers
33 views

Sharepoint 2013 Document Library Excel oData Data Retrive issue

I am trying to retrieve data from SharePoint Document library to excel using oData Data Feed. My Document library name is "2015" and it have one choice field. I am getting the following error when I ...
0
votes
0answers
22 views

VB script to automate importing sharepoint list data to excel

I need to automate pulling data from SharePoint list data to excel through writing a VB Script (not VBA). How can I import data directly from a SharePoint List into Excel using VB script? Currently, ...
0
votes
0answers
17 views

Hide toolbar menu commands on Excel Web Access web part

I'm displaying a Excel Web Access web part on a page in SharePoint 2010. I would like the users to be able to 'Download a Copy' of the workbook. However, I don't want them to to be able to select ...
1
vote
3answers
83 views

PowerShell script to download SharePoint attachments (Excel) with certain worksheet name

I'm trying to write a PowerShell script that will scan a SharePoint list and download an excel spreadsheet if it has a certain worksheet name. I'm not sure of where to start as far as syntax goes... ...
-1
votes
1answer
173 views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
3
votes
4answers
17k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
4
votes
1answer
1k views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
0
votes
0answers
24 views

Excel Bi sharepoint online 2013 features - tutorial resources

Hi i need to work with Excel Bi and unable to find any resources except following link. I need to know what are the features, function available with Excel BI-sharepoint online 2013. ...
-1
votes
2answers
20 views

Excel Web Access issue

I embedded an Excel sheet into SharePoint using the excel web access web part. It works great, the only problem is that it continues to display the Excel sheet on refresh where it was last saved. I ...
0
votes
0answers
11 views

A webpart for Excel web access

We have SharePoint 2010 standard license in our organization, I would like to show an excel pivot table in "SharePoint Excel Web Access webpart" which belongs to the Business Data group of web parts, ...