Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

refreshing data

  Asked By: Shonda Workman         Date: Oct 23, 2009      Category: Sharepoint      Views: 179
 

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?

Tagged:    

 

1 Answer Found

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

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].