Saturday, January 22, 2011

Share Excel Workbooks on SharePoint Server 2010

You can reuse and share Excel workbooks on SharePoint Server 2010 portals and dashboards by using Excel Services.   This means that you can control what data is displayed and maintain a single version of your Excel workbook.
Excel Services supports workbooks that are connected to external data sources. By saving them centrally in a data connection library file on the SharePoint Site, other people could also use the same connection method to view and interact with your data.
To do that you will need to export the data source connection files to SharePoint Site as following:
  • Open the excel
  • Go to Data tab and click on the Connection Properties menu for your worksheetimage







  • Click on the Definition tab and then click on the Export Connection File button on the bottom  image
  • Save the file on a SharePoint site with Office Database Connection extension (*.odc)
image
  • Once the data connection file been saved on the SharePoint site, the location of the connection file should be changed and pointed to the SharePoint Site
image
  • Now you could Save and Publish your Workbook to SharePoint site by Click on the Save & Send  menu
image
Once you did that, other people from your team/company can view live, interactive workbooks you created by using the browser on the SharePoint site.

17 comments:

  1. Great write-up, I am regular visitor of one’s web site, maintain up the nice operate, and It’s going to be a regular visitor for a long time.
    camcorder

    ReplyDelete
  2. Thank you for another essential article. Where else could anyone get that kind of information in such a complete way of writing? I have a presentation incoming week, and I am on the lookout for such information.

    computer store

    ReplyDelete
  3. I real understand your aggregation and you vindicate each and every show very compartment.Thanks for distribution this entropy.And I'll hump to indicate your next stake too.



    Computer Hardware Store

    ReplyDelete
  4. I read your publish . it was amazing. The way you tell about things is awesome. They are motivating and beneficial. Thanks for giving your details and opinions. shyam advisory free trial

    ReplyDelete
  5. SharePoint is typically associated with web content management and document management systems, but it is actually a much broader platform of web technologies, capable of being configured to suit a wide range of solution areas.
    Natural Gas Tips

    ReplyDelete
  6. While doing this work they have faced with a huge problem and they can nor get rid of this now.But on the other hand taking some time hwy will be able to solve this at once.So i wanna wish them good luck.








    Brand Desktop Computers

    ReplyDelete
  7. The stuff here is pretty cool and awesome. I got the meaning clearly and need no longer time to understand it. It’s really interesting.
    Computer Motherboard

    ReplyDelete
  8. Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
    Sharepoint Training in Chennai

    ReplyDelete
  9. They are becomes a more and more interesting from the starting lines until the end.

    Oracle Weblogic Server Training

    ReplyDelete
  10. Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.

    ReplyDelete
  11. Good article. It is very useful for me to learn and understand easily USMLE Thanks for posting.

    ReplyDelete
  12. Thanks For Sharing Valuable Information, Very Useful For U digital transformation consulting

    ReplyDelete
  13. Infycle Technologies, the topmost software training institute in Chennai offers AWS training in Chennai for tech professionals, freshers and students, of any field. Other top technologies such as Digital Marketing, Java, Python, Hadoop, Selenium, Big Data, AWS, Android, and iOS Development will also be trained with complete hands-on training. To get more info and a free demo, dial 7504633633

    ReplyDelete