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.
Posted by at
Labels: ,

17 comments:

  1. DerlierprossyOctober 12, 2011 at 12:28 AM

    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. DerlierprossyOctober 23, 2011 at 5:33 AM

    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. DerlierprossyDecember 9, 2011 at 11:57 PM

    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. MCX TipsApril 27, 2012 at 1:14 AM

    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. MCX TipsMay 10, 2012 at 5:19 AM

    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. Johnmark1478May 18, 2012 at 6:52 AM

    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. Johnmark1478May 30, 2012 at 8:33 AM

    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. Karthika ShreeJune 12, 2017 at 4:19 AM

    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. AnonymousMay 11, 2018 at 1:13 AM

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

    Oracle Weblogic Server Training

    ReplyDelete
  10. Peter JohnsonJune 15, 2018 at 12:56 AM

    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. UnknownJuly 4, 2018 at 3:05 AM

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

    ReplyDelete
  12. UnknownJuly 16, 2018 at 5:45 AM

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

    ReplyDelete
  13. 24LayoutsAugust 29, 2018 at 1:41 AM

    Thanks For Posting From 24Layouts

    ReplyDelete
  14. UnknownNovember 19, 2018 at 1:14 PM

    thanks for sharing such an informative post....

    Vijay Devarakonda Height

    ReplyDelete
  15. Ramesh MarimuthuJanuary 4, 2022 at 3:55 AM

    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
  16. Action Guarding ServicesFebruary 15, 2022 at 4:35 AM

    Hello , Nice Article.
    Industrial security services in hyderabad | Action Guarding Service

    ReplyDelete
  17. Motor Inn Travel PlazaFebruary 17, 2022 at 6:28 AM

    Nice Article.
    Private Showers for Drivers in Mendon,

    Ohio | Motor Inn Travel Plaza
    Gas Station in Ohio | Motor

    Inn Travel Plaza
    Dine-in Restaurant in Ohio |

    Motor Inn Travel Plaza
    Pizza in Ohio |

    Motor Inn Travel Plaza
    Convenience Store at

    Truck Store in Ohio | Motor Inn Travel Plaza
    Travel Plaza in Ohio | Motor

    Inn Travel Plaza

    ReplyDelete

Subscribe to: Post Comments (Atom)