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

learn more… | top users | synonyms

1
vote
1answer
1k 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
3k 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
430 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
214 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
170 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
208 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
286 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
850 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
549 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
265 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
609 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 ...
1
vote
1answer
3k views

Excel new document template opens in Notepad

I have a document library with a custom document template. The template is an .XLTX file that I created using Excel 2010. It is associated to the library via a custom content type. The template ...
1
vote
3answers
2k views

Can an Excel file be used as an external content type?

or an external datasource? Can that be set up in SP Designer 2010
1
vote
2answers
1k views

Can I export a SharePoint 2007 list to an Excel file subdivided into separate worksheets?

We have a SharePoint 2007 deployment which will have a substantially large document library. My client wants the ability to export this library to an Excel spreadsheet, but specifically wants the ...
1
vote
2answers
871 views

How do I make a easy print out (overview like excel) in Sharepoint?

If we use action items for projects/meetings and we want to make an easy print overview, this seems to be impossible. Any ideas or suggestions?
1
vote
1answer
19 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 ...
1
vote
2answers
31 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 ...
1
vote
0answers
17 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 ...
1
vote
1answer
61 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 ...
1
vote
0answers
55 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
1
vote
0answers
34 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 ...
1
vote
0answers
107 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 ...
1
vote
0answers
58 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 ...
1
vote
0answers
27 views

Is it possible to filter chart without refresh?

I have created a chart in excel using PowerPivot and I am using oData Data Feed to get values from my SharePoint List. I have set auto refresh at every 60 minutes and I have used some filters also. I ...
1
vote
1answer
701 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 ...
1
vote
1answer
298 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" - ...
1
vote
1answer
893 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. ...
1
vote
1answer
61 views

Read excel data from attachment and display in SharePoint and allowed to edit

User would like to upload a excel file into SharePoint and he expect system to read his file and display out the data that he have uploaded in SharePoint. Besides, from SharePoint, he requested to ...
1
vote
1answer
243 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
283 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
110 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 ...
1
vote
0answers
368 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
0answers
23 views

Sharepoint Online 365 and refreshing excel files

Is there a way to have the excel files refresh their links hourly or daily?
1
vote
1answer
114 views

How to create an Excel Document when adding a Library Item?

Hope you can help me with this question: I have a SP Library, where the user should type info into some fields (Text, Publishing HTML, Datetime). So, I'm wondering if it's possible to use that info ...
1
vote
1answer
35 views

Port change from 80 to 443 causing endless user prompting when accessing office files

This weekend I changed the main web application to run on https instead of http. This morning when some (not all) users try to check out or edit and office file they are continually prompted for ...
1
vote
0answers
43 views

code for redirecting to a page from a link in excel

I have an application where all my list data is getting exproted to excel. In excel there is a link in a column. On clicking that link it should redirect to a page form excel. Require c# code for that ...
1
vote
1answer
154 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
1
vote
0answers
24 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
0answers
144 views

How to apply “Table Style Medium 4” template formatting to excel created using open xml?

Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation ...
1
vote
1answer
233 views

Custom Field and export to Excel

I have a custom field that inherits the Number field (I change the UI of the field, but not the storage). When I export to Excel a list that contains an instance of this field, I get different ...
1
vote
0answers
25 views

Having issues looking at all old versions

I've been trying to look at older versions of a file but keep getting this error? Any idea what it's happening? I've looked at the source of the document within Excel and it's looking for a copy ...
1
vote
0answers
327 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 ...
1
vote
1answer
340 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
1
vote
1answer
473 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 ...
1
vote
1answer
143 views

IE crash - when copying data from Excel to Sharepoint List

I have an EXISTING SP List, and am trying to copy / paste data from an xls file into the list. I have a view created that mirrors the columns I am trying to copy in. It appears to copy / paste okay, ...
1
vote
0answers
43 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
vote
0answers
207 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
211 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
19 views

How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service

We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...