Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

refreshing data

  Asked By: Shonda    Date: Oct 23    Category: Sharepoint    Views: 871

I have an excel file that has data which comes from SSAS 2008.
I would like to publish it as an excel service in sharepoint
and refresh the data every so often... ( when there is new data , every day, etc..)

what is the best way to refresh the data in excel services in sharepoint?



1 Answer Found

Answer #1    Answered By: Omar Arnold     Answered On: Oct 23

You would configure this in the connection properties to refresh the data  when the file  is opened. This is all setup in the usage tab when you go into the properties section of the connection once you are referencing it in your Excel file.

Here is a reference in regards to your options for refreshing  data with Excel Services - Refresh external data in Excel Services

Didn't find what you were looking for? Find more on refreshing data Or get search suggestion and latest updates.