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

learn more… | top users | synonyms

1
vote
1answer
35 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
3answers
3k views

Can You Enhance the “Export to Spreadsheet” Action for SharePoint Lists?

Do you know of any resources/solutions to enhance the List’s “Export to Spreadsheet” function so that, once the data is opened in Excel, something would trigger VBA Macro(s) to start formatting the ...
1
vote
2answers
1k views

Interacting with Excel spreadsheet from Sharepoint 2010

I'm wondering is it posible to create or modify Excel spreadsheets that are on SharePoint 2010 programaticaly and how to do it?
1
vote
2answers
3k 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 ...
1
vote
3answers
9k views

Does SharePoint support Excel spreadsheets linked to each other?

Is it possible with Office 2007 + SharePoint 2007 to have a spreadsheet uploaded to a SharePoint document library having dependencies/links to other spreadsheets also stored in SharePoint? Thanks...
1
vote
1answer
45 views

how to export to Excel from a webpart

I am using Sharepoint Server 2010, and need to use OOTB features only. I have created a page with a web part on it, using a view from my list. The webpart works on parameters entered on the page. When ...
1
vote
3answers
695 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
vote
1answer
4k views

can we make it “export to spreadsheet” in sharepoint list automated?

my client wants it automated so that the exported csv file will be saved periodically into a location and he can do his necessary action. rather than coming into the site and exporting it each time. ...
1
vote
1answer
466 views

Help using Excel REST

Posted a question yesterday and got a great suggestion to use Excel REST. I've looked at the documentation but had a basic question about how to apply it. I've got 3 workbooks in a document library ...
1
vote
2answers
9k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
1answer
3k views

Having trouble check in excel file in SharePoint 2010

I tried to check in the file to the site. But I got this error message (The system cannot find the file specified (Exception from HRESULT: 0x80070002)). I'm able to check out the file, edit, and ...
1
vote
1answer
1k views

Most “full control” users can't access datasheet view or export to Excel

All but the administrator users with "full control" and/or "contribute" permissons on a certain list do not recieve the datasheet view option, and when they try to export to Excel there is a ...
1
vote
2answers
182 views

SP Alert email cuts off Excel table in Office 2010 but not Office 2003

I have an alert set up for a discussion board. We have been using Office 03 just fine, email comes in, the body is shown fully, everything is great. However, when we use Office 2010, not sure if its ...
1
vote
1answer
19 views

Can i download the Contoso Sample Files for SharePoint

I would like to download the Contoso sample files used in SharePoint 2013 training, is there any place that I can get them.
1
vote
1answer
61 views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
1
vote
1answer
19 views

Doing calculations in Excel Online with user permission “View Only”

I want to share Excel files in a SharePoint library. The users shall only be able to open the files in "Excel Online", but not to download them or the open them offline. Also the original file ...
1
vote
2answers
170 views

Using Chrome to Open an Excel Workbook

I thought there was a way to manage ActiveX extensions on Google Chrome, specifically one that manages how Chrome handles Excel workbooks when you click on the hyperlinked title in SharePoint. Is ...
1
vote
1answer
177 views

Data Connection does not refresh in Excel

I have a SharePoint list; Exported into Excel file and set the property to refresh Data Connection every time the file is opened. It worked very well in Excel installed on my system but when I ...
1
vote
1answer
377 views

How to access Excel cells hosted on Sharepoint (Office 365) using Java client?

I host my site in asphostportal and I am trying to build a Java clinet that connects to Sharepoint (mysite.sharepoint.com) and grabs an excel file. I used the Excel services WSDL file, however the ...
1
vote
2answers
271 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 ...
1
vote
1answer
2k views

Getting fully qualified FieldUserValue instead of actual user name from SharePoint

I'm working on my first C# program, and it's a pretty simple program that uses a view of a SharePoint page to go through and delete things that are older than 5 days on that page. Before deleting the ...
1
vote
1answer
76 views

Registration Form To Populate Excel Sheet

I'm trying to add a web registration form for people to sign up for a lunch and learn. The idea would be once a user presses submit, his/her info would automatically post to the Excel sheet and the ...
1
vote
3answers
863 views

Export selected item from list to excel

I'd like to know if there are a way to export to excel the selected items in a sharepoint list i'm in sharepoint 2010
1
vote
1answer
165 views

Sharepoint List & Export to excel sheet

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ? If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and ...
1
vote
1answer
163 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
1
vote
1answer
1k views

Excel document not updating on open

I have an excel document that is linked to a SP 2010 list. I set the connection and the update on open. It works just fine (i.e. updates with new data) when the file is on my local machine. However ...
1
vote
1answer
836 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" ...
1
vote
1answer
1k views

How to import excel spreadsheet to SharePoint document library?

Excel spreadsheet has several columns including a filename column which has actual path to file, that file should is exactly I want to be imported to document library. Once imported the filename ...
1
vote
1answer
64 views

Windows 7, excel and word 2010 how get RID of Sharepoint popup window? [closed]

When using Excel (and possibly Word) this irritating popup window appears requesting some kind of password. I want to get RID of this window and get rid of Sharpoint, whatever it is.
1
vote
2answers
255 views

Merging excel documents similar to slide libraries

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...
1
vote
1answer
2k views

Generating Excel Export using a link?

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can ...
1
vote
2answers
158 views

Sharing a Spread Sheet on SharePoint and making sure Data changes reflect in document

I have a spread sheet to which i make changes weekly. There are different kinds of data in the spread sheet. I want to make different parts of data visible to different people in my team on the ...
1
vote
1answer
847 views

IF AND CONCATENATE Nested Statement in Calculated Column SharePoint 2010

I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files ...
1
vote
2answers
4k views

Fail to export custom SPList to Excel

Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
1
vote
1answer
7k views

Why are .xlsm files opened as read-only when .xlsx are not?

I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
1
vote
2answers
442 views

Import a single row from Excel spreadsheet

I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row! Is ...
1
vote
1answer
3k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
458 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
1
vote
1answer
2k views

Recovering data from modified infopath fields?

I had built and published an infopath form to a sharepoint library and populated the library with about 50 documents(based on the template) I modified (deletd rich text boxes and replaced it with ...
1
vote
3answers
4k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
1
vote
1answer
543 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
1
vote
2answers
255 views

Excel services refresh using Claims based NTLM?

I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...
1
vote
1answer
184 views

Excel Services Using SQL Server 2008R2 Refresh

I have an excel file set up to pull data from SQL Server 2008R2. I can view it and refresh it fine locally in Excel 2010. I upload it to SharePoint 2010 and can view the data in the spreadsheet in ...
1
vote
1answer
220 views

Edit Document in Sharepoint

I have an issue when editing and save sharepoint Office document. Firstly if I am right clicking on the document and saving it. It is fast and fine. If I try to edit it in office, it opens very slow ...
1
vote
1answer
323 views

Office Web Apps Word - Configure trusted locations

It is possible to configure the trusted file locations for the Word Web App on SharePoint 2010? I only can find the settings to configure the supported file formats at the Word-Service Application ...
1
vote
1answer
936 views

How to add Excel web access web part in WSS 3.0

I'm new is SharePoint and struggling with adding web part. I'm using WSS 3.0. I want to add Excel Web Access Web Part, so I go to site Actions -> Web Part Gallery and try to upload .wdp file which ...
1
vote
1answer
629 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...
1
vote
2answers
279 views

Ability to migrate linked Excel spreadsheets to MOSS

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
1
vote
1answer
706 views

How to bulk update records in a SharePoint List with a lookup column (with type Person)

In SharePoint 2007 I have a List containing two columns: "Title" of type single line of text "Email" of type Person or Group Because I have to update a lot of records, I use export to Excel to ...
1
vote
1answer
2k views

sharepoint 2010 : Download Data as Excel reports

We are working on a share point 2010 application where there is a requirements of complex reporting. As per requirement there will be a Link List which will have couple of links. On clicking these ...