Questions tagged [excel]

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

347 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
2answers
582 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"); ...
6
votes
0answers
100 views

Formula in spreadsheet being converted to a custom list

I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list. The spreadsheet contains the following columns: Received - This will be a number column with 0 decimal ...
5
votes
1answer
2k views

Can't Preview Excel in Office Web Apps but available to view in browser

I recently deployed Office Web Apps for SharePoint 2013, the preview of Excel docs returns We can't show a preview of this item. It will display in a browser if that option is selected. This is a ...
5
votes
2answers
1k 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 ...
5
votes
0answers
9k 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 ...
5
votes
2answers
5k 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 ...
4
votes
0answers
48 views

Fail of export of unchanged view due to unexpected error reported by Excel

A view, which has several times successfully been exported to Excel suddenly fails due to unexpected error reported by Excel. Creating a new view omitting some fields solves the problem, however ...
4
votes
1answer
2k views

Export to excel missing data

When I export a custom list to excel, some of the data in one particular column does not show up. I have a "comments history" column that is created by workflow. Whenever a user enters a new comment,...
4
votes
1answer
2k views

Sharepoint Excel Error IE9 - Workbook is larger than the maximum workbook size allowed to be opened in the browser

A few of my users who are using ie9 for a SharePoint housing a few excel files around 19mb are experiencing a recent issue where they cannot see 'read-only or edit' options; (this is enabled to open ...
4
votes
1answer
1k 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?
4
votes
2answers
9k 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" - ...
4
votes
1answer
1k 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 ...
4
votes
1answer
2k 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"...
4
votes
2answers
3k views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
3
votes
0answers
44 views

ADO.NET Data Services for SharePoint 2016?

As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source. In researching how that can be done, I found ...
3
votes
0answers
508 views

Sharepoint metadata greyed out in Excel file

We are using SharePoint 2013 and Excel 2013, together with Managed Metadata using content types. Some Excel 2013 users are intermittently experiencing greyed out managed metadata fields. They only ...
3
votes
0answers
106 views

Synchronize Excel with SharePoint List programatically using Angular JS

I am working with requirement where I have to develop an Excel Task pane add-in to which will synchronize the data of SharePoint Online list and Excel sheet using Angular JS. Authentication part is ...
3
votes
1answer
180 views

Bulk addition of list items, with single approval

I have received a very strange request from the business teams. They want to move their manual approval process to issue an approval letter from Email currently to SharePoint O365. So I created a list ...
3
votes
0answers
556 views

Excel Services: Configuring Data Refresh for an External Workbook Data Source

Honestly, configuring this has been such a hard experience. I encountered many errors already, one after another but am stuck now. To illustrate what I've come across so far, I've had problems with ...
3
votes
0answers
110 views

Excel webpart showing “Loading” but not showing the excel file

I am using an excel file which uses a dataconnection stored in dataconnection library. The dataconnection gets the data from sql server using Secure store and excel services. I am trying to use the ...
3
votes
0answers
1k views

Connectivity issue from Excel 2010 to SharePoint

We are using Excel 2010 and was running in Window XP. Connectivity with SharePoint was good. Recently our environment got migrated from XP to Windows 7. Until that point we are seeing the following ...
3
votes
0answers
2k 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 ...
3
votes
1answer
2k 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 ...
3
votes
0answers
217 views

Cannot Open Excel sheet in web-browser

I am having a problem opening the excel sheet in web browser, it throws an exception.. Excel Web Access >> An error has occurred. Please contact your system administrator if this problem ...
3
votes
1answer
745 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 ...
2
votes
1answer
49 views

Sharepoint Excel Web Access Web Part double scrollbars

This has been very annoying for me. I searched for hours now in order to solve this. However I have not been able to find a satisfying solution. On a SP Webpart page I have added an Excel Web Access ...
2
votes
2answers
5k views

Conversion of csv file to xlsx via Flow or SharePoint

I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how ...
2
votes
2answers
1k views

'Open In Excel' option is grayed out for .xlsm files in Sharepoint 2013

We know that excel files with macros and password protections are not supported to view in Browser using Office Web App / Excel Web App. In this SharePoint shows small dialogue where it has 'Open In ...
2
votes
0answers
16 views

Save file in same document set it is opened from

I have a request from a customer I am struggling with. Given is the following scenario: SharePoint Server 2016 Whenever a new document set is created a specific Excel file is added to the document ...
2
votes
0answers
490 views

SharePoint, local sync and Excel linked workbooks

We have a file share hosted in SharePoint Online, which users sync to their local PCs using the OneDrive desktop application. What's the best way of managing links between Excel workbooks in this ...
2
votes
0answers
32 views

Endless Pop-ups Trying to Save Word with linked Excel files on SharePoint

I have a Word document saved on SharePoint 2013 that contains a large number of linked objects (tables from Excel files and bar charts from Excel files). When I click Save on the Word doc, I start ...
2
votes
0answers
2k views

How to update existing sharepoint list using excel?

How will i update my existing list items with a new updated excel sheet?
2
votes
2answers
2k views

How to export SharePoint list data to xls or xlsx format using poweshell

I want to export SharePoint2013 list data into .xlsx or xls using PowerShell. In my server, there is no Excel installed.
2
votes
2answers
3k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
2
votes
0answers
126 views

File Linking: Excel to Access to Excel

My organization is small and uses SharePoint to store our shared files enabling us to access shared files from each of our desktops. However, when we link files while they are on our desktop they ...
2
votes
3answers
120 views

Import from Excel to an existing Sharepoint 13 list

I have to update my existing Sharepoint (2013) List with data from an Excel Sheet. I've only found an old Add-In for Sharepoint 2007. Which other possibilities do I have?
2
votes
1answer
284 views

Way to Preserve Links when Moving Excel files from File Share to SharePoint?

Is there a way to preserve the links that connect Excel files that are stored on a file share but are moving to SharePoint?
2
votes
1answer
2k views

Export list to Excel - 50'000 limit

We have a user that has a SP2013 list with nearly 100'000 items. In a previous SP2007 environment, they could export the entire list to excel. In SP2013, they are hitting a hard limit in Excel of 52'...
2
votes
1answer
2k views

Sharepoint Excel file opens Read Only when edit is selected

A user on a team sharepoint who has contribute permissions is getting a 'read only' version of ONE of the files in a folder. All other users can open normally and edit. However, when this user selects ...
2
votes
0answers
206 views

Read the entire Excel file in atom format using Excel Services

I am trying to read Excel file stored in Document Library using Excel Services. I need to fetch the entire workbook content in a single request call. I have tried using Ranges using it like http://&...
2
votes
0answers
55 views

Synching select rows from an Excel spreadsheet into a SharePoint 2013 List?

I know you can connect Excel and SharePoint 2013, but is there a way to "selectively" sync data from an Excel Spreadsheet into a SharePoint List? Basically, we have a master spreadsheet where each ...
2
votes
0answers
71 views

Link Access to a SharePoint file whose name keeps changing

I have an Access database that I would like to link to an Excel file located on SharePoint. Normally, this is easy to accomplish as SharePoint/MS Office are well integrated. The problem is, the Excel ...
2
votes
1answer
1k views

Can't crawl Excel 2003 files from SharePoint 2013

I have a SharePoint 2013 farm and am crawling the contents of a legacy SharePoint 2007 farm on the same network domain. I am getting the following error crawling Excel 2003 files (i.e. xls format) ...
2
votes
0answers
416 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 ...
2
votes
2answers
444 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 ...
2
votes
0answers
349 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: ...
2
votes
2answers
1k views

Prevent User saving excel document back to Sharepoint

I have users on Excel 2010 and they are accessing a sharepoint site using Sharepoint Services 3.0 and clicking on the excel document and the default behaviour is to save this back to sharepoint rather ...
2
votes
0answers
97 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
0answers
1k views

Cannot Save Excel to Sharepoint

One of my users is having an issue saving to Sharepoint with some very specific parameters. the problem is related to saving only from within excel if a document has been opened from SP. She is ...
2
votes
1answer
75 views

Sharepoint 2010 issue with exporting certain combination of columns from a view

so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...

1
2 3 4 5
7