Saturday, January 12, 2013

How to do Calculations in Excel Sevices?


Microsoft Office Excel 2007 allows to specify different calculation formulas in a workbook.
Once the formula is set up in a workbook and published to sharepoint Excel Services,Excel Calculation setting is supported and retained in the workbook.
To perform the calculation or recalculation:
1.    open the appropriate webpart page .
2.    Open the workbook in excel web accesss webpart
3.    On the webparts toolbar,click the update menu and then click the Calculate workbook
4.    Repeat the steps to recalculate

5 comments:

  1. Free Work At Home Job Work At Home Completing Simple Surveys From Home. No Registration Fees. Join Today (Http://Tinyurl.Com/3gce3ot) Ids (11658)

    ReplyDelete
  2. Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
    Best Selenium Training in Chennai | Selenium Training Institute in Chennai | Besant Technologies

    ReplyDelete
  3. All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.

    angularjs-Training in velachery

    angularjs-Training in annanagar

    angularjs Training in chennai

    angularjs Training in chennai

    ReplyDelete
  4. I appreciate that you produced this wonderful article to help us get more knowledge about this topic. I know, it is not an easy task to write such a big article in one day, I've tried that and I've failed. But, here you are, trying the big task and finishing it off and getting good comments and ratings. That is one hell of a job done!
    Python training in marathahalli | Python training institute in pune

    ReplyDelete
  5. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    Online DevOps Certification Course - Gangboard
    Best Devops Training institute in Chennai

    ReplyDelete