SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using Excel Web App for Sharepoint 2010.

We have customized page so we have added a button in a ascx control to add a row using open XML SDK 2.0. How can we refresh page in order to see the new row added to the Excel?

share|improve this question

I would try the EWA.Workbook.recalcAsynch method. There's a good example of it in this blog post.

The above example shows using a timeout to set a short delay before the control refreshes. If you wire this into the click event of your button, the delay might come in handy if you're adding a new row asynchronously.

If you're writing server code, it might provide a better alternative. I'm less familiar with the Excel Web Access Server APIs.

share|improve this answer
Thanks for your response, but I think Excel Web App doesn't support this methods, as shown in this comparison. I am newbie to Sharepoint 2010, so I'm not sure if it is possible to use them. – Alfonso Oct 18 '11 at 7:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.