.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Opening an xlsx document in SharePoint 2010

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Hi, please can you help? We have SharePoint 2010 installed and using Internet Explorer 7 along with Microsoft office 2007.When a user attempts to open an uploaded excel document (xlsx), an error message is displayed as below The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser: • Data validation Would you like to try and open this file in Excel? Learn more about unsupported features If the user, then opens and then closes the document, the screen does not return to the user's site. This is not the case with an xls document. If you can assist in pointing me in the right direction, i would be very greatful. many thanks in advance Alec

View Complete Post

More Related Resource Links

Opening pdf from Sharepoint 2010 Document Center


Is there a way to open a PDF in a web browser, just like Office Web Apps?  Everything I've tried results in the PDF being saved first.  I do not want to save these files, I only want to view them.



Opening Word 2003 document from sharepoint site in word 2010.


When using sharepoint services with word 2003 on an XP machine, everything works fine. We bought some new computers where we now have windows 7 and office 2007/2010. These work perfect too. Even the 64-bit computers.

We are very happy with the new office version, so we decided to upgrade the entire company. As a test, we upgraded 1 PC. But this is not working. So we upgraded office, later we reinstalled it. But nothing helps. This is the problem: I surf to the document click it to open it, and then Word hangs. "contacting server". This is not always the case, sometimes it works, sometimes it doesn't. This even with the same document.

We would really like to upgrade to office 2010 entirely. But we're not going to buy licences we cannot use. Anybody got a solution?

Video: SharePoint 2010: Advanced Routing and Document Sets

Learn how to work with document sets such as RPFs (Request for Proposal), which may be made up of multiple documents such as the question document, the answer document, and many other supporting documents and files. (Length: 13:56)

Video: SharePoint 2010 Document Libraries

This demonstration delves into working with document libraries and documents programmatically. (Length: 5:39)

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Upload documents to Sharepoint 2010 Document library

Is there a way to upload documents to an SP 2010 document library with Custom Actions or Workflows?  I have a requirement of taking the contents of several directories (older data files) and uploading them to Sharepoint.  Not sure which actions actually perform this operation.  Any help most greatly appreciated.

sharepoint 2010 document conversion job started but never completes

I trigger the conversion of a Word.docx file to convert to PDF but the Job never completes. It just says this under the status column but nothing under the outcome column. I have waited for 48 hours to be sure it just wasn't slow. "Conversion Job with Id=00000000-0000-1064-8041-acbca36dcb07 started" There is nothing in the event log nor in the Sharepoint Log that says there is a problem.  

Office 2010 can not integrate with Sharepoint Server 2010 document library, both RTM

Hi I have one standalone SharePoint Server 2010 and Office 2010 on Windows Server 2008 SP2. Both SharePoint and Office are RTM. When I create new document from the document library, it can open the Office Word.  When I save the document, Office gives me the local browser dialog other than remote sharepoint library. When I try to enter the sharepoint site url in the dialog, it tells me: path does not exist. On another machine, Windows 7, the Office 2010 RTM can open and save docs from/into the document library. There seems something wrong with the Office client. Maybe someone can tell me how to fix it. Thanks. Xiaofeng?????,?????@??/??/????+????+????+all the context of the issue Hope Helpful | http://www.leoworks.net

how do I pass in a standard xml+xsl to be converted through the Sharepoint 2010 Document Conversion

How do I pass in a standard xml+xsl to be converted through the Sharepoint 2010 Document Conversion? Via the SDK I have been able to code a c# workflow that converts word files in a Sharepoint 2010 Document Library (docx,dox, word.xml) to PDF successfully but want to pass in an xml+xsl file to this engine if possible. Actually I have xml, xsl, and if needed xsl-fo files to deal with but would be happy if I could figure out how to make the Document Conversion engine do the xml+xsl transform and then send that to a doc file in Sharepoint.    

SharePoint 2010 Office Web Apps "Word Web App cannot open this document for viewing because of an un

<label id="message" class="WACStandardDialogLabel">I have provisioned a SharePoint 2010 Server (RTM: 14.0.4762.1000)  with Office Web Apps.</label> <label class="WACStandardDialogLabel">It is a single server with a separate SQl 2008 Standard server.</label> <label class="WACStandardDialogLabel">I have seen that there were some issues in site that were configured with a port.  The Web Application I am having issues with is running on a port  and is extended on 443 as well.</label> <label class="WACStandardDialogLabel">I can view PPTX but Word docx files can't be viewed.  The word docx files howerver can be edited in the browser.</label> <label class="WACStandardDialogLabel">I get the following error when I try to view a word file in the browser:</label> <label class="WACStandardDialogLabel"></label> "Word Web App cannot open this document for viewing because of an unexpected error. To view this document, open it in Microsoft Word. Error Id: 7f644fec-c2d7-4387-b280-31a4647afea1, 20100509213834 " I am seeing an error in the event log that identifies the Application Service account (that includes the Word Viewer Service) can't access the portal site collection database.  -I am using the appl

"This document could not be checked out." SharePoint 2010 checkout action using IE8

I am setting up a two-server farm, and most everything works, except the checkout action for a document.  This problem occurs in both site collections, one of which requires checkout, and the other does not. Here are the options I've tried: Snow Leopard, Firefox 3.0.1 - works Snow Leopard, Safari - works Win 2003, IE 7 - works XP, Firefox - works XP, IE 8 - "This document could not be checked out.  You may not have permission to check out the document or it is already checked out or locked for editing by another user." In IE8, I am able to open a document as read only then use the button presented by Word to check out the document.  I cannot use that as a workaround, as not all users have a version of Office that will allow checkout in that way. Checkin works fine.  I need to resolve the checkout error.

SharePoint 2010 Claims Based Authentication - anonymous site is prompting for CBA auth when opening

Hi, I have CBA setup successfully on my sites.  One site is setup for anonymous access and I have disabled "client integration" on that web application. I have a list of MS Office documents on a wiki.  When I click on one I am asked to either save or open or cancel.  Saving works fine but when I choose open, it launches the associated MS Office app.  I am then prompted for a login from CBA.  I can click cancel and the logon screen appears again.  After clicking cancel the 2nd time the document appears in the MS Office app, Word in this case. My question is how do I prevent my users from being prompted for a CBA login when clicking on these files and opening them in the native app on their machine?      --TR

Intercept Check-In Event of Document Library in SharePoint 2010

we need to intercept the default check-in Event of the Document Library. The detailed requirements is as follows.   1. Intercept the check-in Event of Document Library. 2. Instead of the default check-in  page (normally this is the layout's checkin.aspx page), show our custom application page. 3. In the custom application page, allow users to provide some inputs. Validate the input values against values stored in database. 4. Once validated successfully, allow user to check-in the documents. Else, do not allow user to check-in the document.   One more additional requirement is the above things should happen only for our custom content type. In order to achieve the same, we are planning for deploying our custom document content types and perform the above operations on check-in event of the documents.     Another approach of performing the same is , have our own custom ECB Menu. The detailed process is as below.   a. Customize the check in menu (ECB) b. Show the custom form and get the inputs from user and do the validations c. On the OK button click, if validation is success, then update the meta data and check in the document or deny the process. d. But in this approach, we need to check the libraries version settings and that default functionalities should be added automatically to the check in process.   At this point of time, we a

Migrate/Move Document Library from Sharepoint 2007 to Sharepoint 2010

Hi, I have a customer that is setting up a new SPS 2010 environment. They have a Sharepint 2007 environment with one document library containing only PDF files. They will not need any metadata on these documents, but would like it to be moved to the new SPS 2010 environment only to be used for history and free text search. Is there an easy way to accomplish this?   Regards Christian GrannesChristianLLoyd

Sharepoint 2010 Fast Search - Searching Document set

We have a sharepoint 2010 Fast server. We are planning to use document sets to store documents with common metadata.(Previously were using zips in moss 2007). Now, the requirement is we need to return only  document sets even if the search results contain multiple documents within that document set. ie, if we searched for a keyword that was specific to a document within the document set, the search results should return the document set and not the individual documents. Please help!!! Thanks in advance      

Can SharePoint 2010 Tag Cloud webPart show managed keywords tags only from Document Library

Can SharePoint 2010 Tag Cloud webPart show managed keywords tags only from a specified Document Library ? Also can i add multiple document libraries tagged for a single tag cloud webpart?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend