Refreshing data inside an opened workbook

Question

Hi,

after the publishing of some workbooks, I need to refresh data inside them by clicking the Data ==> Refresh Selected Connection.

Do I need to configure a schedule for the data refresh? Or is this manual operation indipendent respect to the authomatic schedule?

Thanks

Answer 1

Hi!, in this place may be find answer your question.

http://technet.microsoft.com/en-us/library/gg413467.aspx

or maybe you enable data refresh from the odbc connection.

http://blogs.office.com/b/microsoft-excel/archive/2008/03/24/setting-up-excel-services-to-refresh-workbooks-when-opened.aspx

but in this page you can too find a flowchart of Excel Service

http://technet.microsoft.com/en-us/library/hh369968.aspx

 

Regards.

Answer 2

Hi Emerson, thank for your reply.

Your first link refers to the authomatic data refresh and I want to know better the manual refresh inside an opened workbook.

The 2nd link refers to MOSS 2007 and not SharePoint 2010.

The 3rd link it isn't very clear.

Thanks

Answer 3

Hi pscorca,

There do exist two type of Refreshment: Manual Refreshment/Authomatic Data Refreshment. Actually PowerPivot load an in-memory engine called the Vertipaq engine that aids in storing imported data efficiently, once you click Refresh button manually, PowerPivot sends a command to the Vertipaq engine to update any metadata changes that you might have done in the PowerPivot modeling window and then retrieves the most content from external data sources.

PowerPivot sends two commands to the Vertipaq engine when you click Refresh button, that is Alter and Process, Alter makes any metadata changes you might have made in the PowerPivot Window. Process command refreshes the data from external data sources an any calculation that depend on the refreshed data.

To Authomatic Data Refreshment, we should leverage PowerPivot data refresh timer job. This timer job is responsible for calling the PowerPivot System Service (PSS) whose task it is to check the queue of scheduled data refresh jobs. When the timer job runs, it verifies which data refresh schedules are past due according to the schedule’s specifications. That is, the system checks to see whether the current time is equal to or greater than the date and the earliest start time specified in the data refresh schedule. If there are runnable data refreshes, and if there are available resources to process it, a server with enough memory and CPU will kick off the data refresh process.

If you have any other question, please feel free to let us know.

Thanks,
Challen Fu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Hi Challen, thanks for your reply, but I need more information about how using the manual Data Refresh. In order to refresh manually a workbook, is it enough to publish the document and then click on Data --> Refresh All Connections?

I've tried to do it but with no effects. ?

Many thanks

Answer 5

Hi, I've also tried the solution in the blog

http://blogs.office.com/b/microsoft-excel/archive/2008/03/24/setting-up-excel-services-to-refresh-workbooks-when-opened.aspx

suggested me to Emerson but unsuccessfully.

I think that the voices Data ==> Refresh Selected Connection and Data ==> Refresh All Connections, visible after the opening of a workbook, are disabled when the workbook is published on SharePoint platform.

Thanks