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

learn more… | top users | synonyms

0
votes
1answer
571 views

Is it possible to set up an ODBC connected Excel spreadsheet on SharePoint 2007 with a Standard license?

I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type ...
0
votes
1answer
703 views

Export an agenda in a meeting workspace

I have a meeting workspace with a recurring meeting. (WSS 3.0 hosted by Network Solutions) When I export the agenda to Excel I get the previous agendas as well as the one for the selected meeting. ...
0
votes
0answers
3 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
0answers
15 views

Insert SharePoint metadata into excel cell

What is the best way to create a system that inserts metadata fields of the document in SharePoint in a cell in Excel? I've done this behaviour multiple times in a Word document using the 'Quick ...
0
votes
1answer
20 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
16 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
0answers
16 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
0answers
21 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
0answers
22 views

Sharepoint list 2010 connecting to excel refresh data

I've managed to export all the files to Excel and upload it to Sharepoint location. This Excel file is used as table of content of all documents that we have in our company. I've also managed to set ...
0
votes
1answer
80 views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
0
votes
0answers
19 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...
0
votes
0answers
10 views

Excel slicers change height on Sharepoint

I've got a report that I publish on a Sharepoint site. When it's on my machine the slicer "size" "height" is set to 1.52". Once I load it to the Sharepoit site and someone opens it and edits it in ...
0
votes
0answers
22 views

HTML tag rotation only rotates dimensions but not text within

I saved an Excel sheet as an HTML file and I needed the header text to rotate 270 degrees. I made it work on all browsers while I edited and tested only as an independent HTML file, but when I added ...
0
votes
0answers
31 views

Excel web part not working in Chrome when navigating back to page

I have a page that is using Excel web parts that has links to documents that they can view. When they navigate back from the document the excel web parts aren't loading. This is only happening in ...
0
votes
0answers
11 views

Get the email of logged in user in Excel on SharePoint?

Get the email of logged in user in Excel on SharePoint? Since VBA doesn't run in O365 does anyone know a way to get email? I am trying to do reporting based off of email so a user only sees data in ...
0
votes
1answer
9 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
0answers
16 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: ...
0
votes
1answer
52 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
1answer
34 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
0answers
19 views

SharePoint Portal

I am completely new to the SharePoint development environment, though I have experience in VBA. I am attempting to create a SharePoint site that will allow several vendors to view an Excel ...
0
votes
0answers
8 views

Excel Web Part: add a chart with an ambiguous name

I have an excel file with a bunch of macro-generated charts in it. The charts span across different sheets, and when the macro runs to generate them, they get different names every time. I want to ...
0
votes
1answer
62 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
0answers
43 views

Export to Excel is slow

I am working with SharePoint 2010 / 2013. Very often I have to export large lists (>1000 Items) to Excel. This always takes some time (e.g. about 3 Minutes for 3500 list items). Is this normal, or ...
0
votes
0answers
17 views

SharePoint Designer 2013 and Excel issue

I have custom Excel addins which were getting loaded and working (in Excel 2007,2010) before installing MS SharePoint Designer 2013. After installing it the addin is always getting the LoadBehaviour ...
0
votes
0answers
8 views

Loss of formulas when using excel to move sharepoint lists

I need to move a list in Sharepoint 2010 from one site to another. I have tried doing this by (1) saving original list as an excel worksheet and (2) creating a new list from that worksheet. The ...
0
votes
0answers
21 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
308 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
1answer
26 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. ...
0
votes
0answers
17 views

Cannot connect to server Excel file

I have a user in my company's portal (SharePoint 2007) that cannot upload changes made in an Excel file. He needs to have the compatibility view active in IE in order to be able to open the ...
0
votes
0answers
45 views

How to get list data to Excel to create chart with date filter?

I have to create chart from a custom list in o365 site. There is one column named "Due Date" in my list. I want only those records whose Due Date is today or gone, I mean Due Date <= Today. How ...
0
votes
0answers
21 views

Show User List in Cell Value of Excel App

I had created an app using Import Excel SpreadSheet. I have one column named as "User" in the list. I want whenever any user add the record in the list, for "User" column it should show list of ...
0
votes
0answers
27 views

Excel web app 2013 title field disapearing

We have a document library that users will be using office web apps to edit. When using Word or PowerPoint, everything works fine. When they use Excel, it gets weird. When they edit a document, ...
0
votes
2answers
112 views

Exporting SharePoint Members into Excel

Is there a proper way to export a group of sp group members into excel? I have been able to select a group from permissions and export them into excel. The problem I face was that even when I ...
0
votes
1answer
246 views

Sharepoint 2013 pasting text into a cell of multiple lines type

I am trying to copy & paste a cell of data from excel to my sharepoint list. The excel cell of data consists of multiple lines of text, so when I copy & paste in the data it pastes it onto ...
0
votes
1answer
124 views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
0
votes
1answer
33 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
0answers
80 views

This workbook was opened from a server in read-only mode

I'm double clicking an odc file stored in the connections library of a SP site. When the workbook opens I get the following: The error window pops up when I hit Edit Workbook - can anyone shed any ...
0
votes
1answer
89 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
0answers
22 views

'Invalid signature' in Excel 2007 when trying to open an Excel file

In SharePoint 2010, I'm trying to open an Excel 2007 document, there I get following error: "Invalid Signature". Still the certificate of the user is valid.
0
votes
1answer
51 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
0
votes
0answers
51 views

Excel error: Cannot connect to the SharePoint list

I am trying to export some data from external list to Excel 2010 and the error is: Cannot connect to the SharePoint list (My SharePoint Server is 2013). However when I do that within Excel ...
0
votes
0answers
21 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
0
votes
0answers
14 views

Linking to sheet number 2 on an embedded Excel Web Access

I want to link to one of my sheets in an embedded spreadsheet (using Excel Web Access) from another page - is this possible?
0
votes
1answer
76 views

Excel Online - Enter Array Formula

In Microsoft Excel entering an array formula requires using the keyboard combination: Ctrl Shift Enter How can I enter an array formula in Excel Online (the WebApp version of Excel). Is there ...
0
votes
1answer
43 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
1answer
63 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 ...
0
votes
0answers
27 views

save excel spreadsheet to cs to sharepoint server

I am trying to save an Excel spreadsheet to .csv to a SharePoint server but running into issues Within an Excel document, I go to: File > Save As > change the file ‘save as type’ to csv (comma ...
0
votes
1answer
70 views

Filling SharePoint Calendar List With Bulk Data(About 3000 Entries)

I want to fill about 3000 entries in a SharePoint calendar List for testing purpose. I have tried using this link but i have some lookup columns and person/group fields which do not appear in the ...
0
votes
1answer
116 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
0answers
176 views

Excel Online - refresh data in a SharePoint list

I have added a SharePoint list to an excel spreadsheet as an odata feed. This data connection refreshes perfectly using Excel on the Desktop. However, when I refresh the connection in the Excel web ...