Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Get an "Excel Web Access" web part to "Reload Workbook"

  Asked By: Pankaj    Date: Feb 03    Category: MOSS    Views: 3703

I have an Excel spreadsheet on my portal (SharePoint 2007). I have a site with
an "Excel Web Access" web part that displays "Chart 1" from this spreadsheet. I
need the chart to update when the spreadsheet changes. The only way I can do
this is to select the "Reload Worksheet" option from the web part tool bar. I
want the reload to happen when the read-only user browses the page.

Or - is there an Excel update service that runs on an interval that would do
this?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Daniella Landry     Answered On: Feb 03

It appears there is a background Excel service running that refresh the
chart data. Seems to be around 20-30 minutes or so.....

This will work in my case.

 
Didn't find what you were looking for? Find more on Get an "Excel Web Access" web part to "Reload Workbook" Or get search suggestion and latest updates.




Tagged: