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

learn more… | top users | synonyms

0
votes
0answers
101 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
2answers
515 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
0answers
104 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
52 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
54 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 ...
1
vote
1answer
109 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
180 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 ...
1
vote
0answers
155 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
118 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 ...
0
votes
1answer
445 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 ...
0
votes
0answers
37 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
30 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
47 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, ...
1
vote
3answers
694 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... ...
0
votes
0answers
46 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
93 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
69 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
14 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
76 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(){ ...
2
votes
2answers
42 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
61 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
55 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
20 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?
4
votes
2answers
5k 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
0
votes
1answer
308 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
36 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
43 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
55 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 ...
0
votes
0answers
119 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 ...
0
votes
0answers
60 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
102 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
39 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 ...
1
vote
1answer
248 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
1answer
1k 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 functionality, it also exports two columns called Item Type and Path. Is there a way OOTB or programatically to exclude these columns from ...
0
votes
1answer
25 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, ...
1
vote
2answers
2k 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 ...
2
votes
1answer
156 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 ...
0
votes
1answer
91 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
0answers
115 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
770 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
57 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
100 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
18 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 ...
1
vote
1answer
1k 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 ...
3
votes
2answers
2k 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
1answer
29 views

Alternative ways to read excel in Sharepoint

Now I'm facing with a problem of reading excel file on SharePoint server. In the old ways I usually use the OLEDB to read excel through the connection string, but it's just work on 32 bit system, ...
0
votes
1answer
160 views

SharePoint Exports to Excel, can't I get directly in .xlsx file?

I am using SP 2013 foundation. I am able to export list into .iqy file. Which is good. But users wants directly .xlsx or .xls files. Is it possible to do that?
0
votes
1answer
11 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
737 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
476 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 ...