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

learn more… | top users | synonyms

0
votes
0answers
18 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, ...
0
votes
3answers
3k views

Open docs from SP2010 in excel/word crashes

I have: SP2010 rented from a company. 1 site collection I have IE 9.0.8 For about a 6 months I have this consistent problem. When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
0
votes
0answers
20 views

Prevent “We're opening your workbook in Microsof Excel” message from being displayed

I have multiple environments with SharePoint solutions installed on them. Almost all of them are working fine except one that has an issue and don't know how to solve it. Each time I open an Excel ...
0
votes
0answers
58 views

Opening a SharePoint file using a hyperlink

On a browser-based SharePoint drive, the default file-opening functionality for an macro-enabled Excel file is to open it directly in Excel; no asking for Open/Save As, no intermediary steps; when the ...
0
votes
0answers
38 views

SharePoint 2013 form workflow in SharePoint designer export dictionary to excel

I am new to SharePoint and I am a little bit lost in here. I am in the SharePoint designer making a workflow, this one I'll export into visual studio and then deploy it, the problem that I have is ...
0
votes
0answers
13 views

How can I add the option for an end user to save an excel version of a Sharepoint 2010 table?

I tried taking the code from the button called "Save to Excel" in the top bar when editing but I'm trying to figure a way to allow end users on a site to download via a button on the actual page. ...
0
votes
0answers
41 views

Opening Hyperlinks inside Excel WebAccess webpart in the Same Window

I have the same question as in this link, but this solution is not working for me. $(document).ready(function() { $(".ewr-sheetcontainer a").each(function(){ ...
3
votes
2answers
29 views

Is Claims-based authentication Required for Kerberos and Excel Services?

I'm trying to setup Kerberos for Excel Services + SSAS. SharePoint Web Application pool using Classic Authentication. I was wondering if it's necessary to switch it to claims-based. I've found zero ...
0
votes
0answers
40 views

Dynamically change workbooks in sharepoint excel web part

I have created a custom ajax visual webpart that hosts an Excel workbook(say summary.xlsx) using ExcelWebRenderer class and i have LinkButton in the same webpart. My requirement is - when users clicks ...
0
votes
1answer
30 views

Sharepoint Excel files Capacity Planning

I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria. I need to plan for capacity in SharePoint, so I need ...
0
votes
1answer
19 views

Excel File Disappear in Excel WebPart

I created excel web part. The webpart worked properly. But now, it isn't work. I got this error. I controlled excel file, it opened. But it disappear in webpart. How can I solve this problem?
0
votes
1answer
112 views

SharePoint 2010 - Calculated Column w/ Hyperlink & IF Statement

I am having some trouble getting this to work. I need to create a hyperlink in a column and learned that if you put some html into a calculated field and format it as a number then it works. For ...
0
votes
1answer
29 views

SharePoint Server 2013 questions

I'd like to know three things about MS SharePoint Server 2013. As I'd like to simulate the version that enterprises are using, is the SharePoint Server a good version to simulate an Enterprise ...
1
vote
0answers
35 views

Open In Excel Issue

I have two sites on SharePoint2013. I used excel webpart. I worked these sites in IE 11. "Open In Excel" works a site, but doesn't work other site. What is the cause of this problem?
0
votes
0answers
40 views

Create Powerview Reports from Sharepoint 2013?

Can you create Powerview reports directly from list data in Sharepoint 2013, without going through Excel 2013? If so, can you point me down the path for the first several steps? All the information ...
1
vote
2answers
389 views

create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013?

I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content ...
0
votes
0answers
55 views

Why can't we save changes in Excel Web Access without opening the file in Excel?

I would like to know if there is any way to make changes to an excel sheet through Excel Web Access Web Part without opening it in excel. I've seen that we can type in and add formulas but the ...
1
vote
1answer
64 views

Removing fields from document properties bar on Excel sheet linked to SharePoint library

I have an Excel sheet which is linked to a library in SharePoint, which has a 'Document Properties - Server' section at the top. They fill out the Excel sheet, save it to the library, and the ...
0
votes
0answers
34 views

Excel refresh and PowerPivot refresh

We're using SharePoint 2013 SP1 and developing dashboards in Excel 2010 with 2012 PowerPivot for Excel. This means that interactive refresh (e.g. refresh on open) is NOT supported according to: ...
0
votes
0answers
46 views

Excel File URLs to test SharePoint site existence

I have the following Excel Macro that reads a list of URLs (1500+). I'd like to be able to clean this list out via some macro flag that is returned so I can parse the list to valid URLs. Right now I ...
0
votes
1answer
36 views

Advise on how to share excel with other users

I am looking for advice on how to resolve the following issue. As part of a volunteering project I have automated an Excel spreadsheet using VBA. I have written a lot of code that includes user forms ...
2
votes
2answers
541 views

Using firefox to edit office documents inside my document library

I have a problem in understanding what is the standard approach to follow for editing office documents inside my document library. As it seems each browser will have different behavior when it comes ...
0
votes
0answers
28 views

Export Data to MS Excel

I have an example that I would want to achieve when I apply Infopath in Sharepoint. Is this possible? Assume that there's a request form in Sharepoint with the following details: Name = using ...
0
votes
0answers
60 views

Excel PowerQuery say “The User was not authorized” , when i am trying connect to a sharpoint list that I have full control permisson for it

When I am trying to connect to a sharpoint2010 list -that I have full control permisson for it-, with OData feed connection , Excel PowerQuery say "The User was not authorized" . I work in a windows ...
0
votes
2answers
495 views

How to show version number when using 'Export to Excel' command

my firm is transferring a project to another firm. The new firm wants a list of all of our files. I went into our sharepoint library and selected "Export to Excel" which returned a spreadsheet with ...
0
votes
0answers
38 views

SharePoint 2010 & Excel Services & Errors

Good Evening All, I've been trying to configure automatic data refresh on excel spreadsheet that's hosted within an Excel web part. My spreadsheet pulls data from a SharePoint list into a pivot table ...
0
votes
0answers
26 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 ...
1
vote
2answers
2k views

'Export to Spreadsheet' error

I'm working with WSS 3.0 and have access to a number of sites within SharePoint. I and a number of other users have run into an issue that is happening when we try export a list using the "Export to ...
0
votes
0answers
121 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 ...
2
votes
2answers
323 views

How to get my deleted columns back in an Excel file, that were exported from SharePoint lists

I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I ...
2
votes
3answers
1k views

List containing Managed Metadata when exported to Excel using Ribbon, has weird hash tags - how to clean?

I have a calendar All Events list which contains few fields, some from Managed Metadata and People presence lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each ...
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
136 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
38 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 ...
2
votes
1answer
60 views

Embedding an Access database in SharePoint?

I have a client who would like me to embed an access database from another location (document library) to a SharePoint page in an editable format. Similar to how you can add the "Excel Web Access" web ...
5
votes
1answer
3k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
0
votes
1answer
65 views

How To Create An Excel Type Grid Application In SharePoint 2010

I have a requirement to create an application in SharePoint 2010 where the user interface presented is like a grid/spreadsheet. But each cell in the grid needs to represent a SharePoint item in a ...
0
votes
2answers
61 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
0answers
396 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
41 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
1answer
16 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 ...
5
votes
1answer
2k views

Check in error “We can't do that becuase the file is no longer checked out or has been deleted”

SharePoint 2013, Office 2013 Std 32 bit. Win7 Pro 64bit Sp1. I've got an issue with checking my .XLSX file back in after any edits. Error message is as follows: "We can't do that because the ...
1
vote
4answers
2k views
0
votes
0answers
25 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 ...
2
votes
2answers
4k views

Working with data imported from Excel into a SharePoint List

I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
6
votes
0answers
220 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
1
vote
1answer
390 views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
2
votes
2answers
474 views

Link on wiki page to Excel document that opens in Excel Online

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online. When I create the link using Insert -> Link ...
0
votes
0answers
26 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
1answer
229 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 ...