Refresh workbook when opening...

[ravindra_tumuluri]

Hi Experts,

I am on NW2004S, BI 7.0.

I have created a workbook for one query. I want the workbook to be refreshed everytime, a user tries to run it.

Any advice ?

PS: I am aware of the solution in older versions..

[Former Member · Accepted solution]

According to SAP Help-->

<b>Refresh Workbook on Open</b>

<i>If selected, when you open a workbook from the server, the query is automatically refreshed with values from the server. If not selected, of if you are opening a workbook from your local file system, you must manually refresh the query after you open it to retrieve the latest results from the server.</i>

Go to the Design Toolbar, the last button, workbook settings will allow you to select this.

Thanks,

Jeff

[Former Member · Accepted solution]

How this can be achieved in Old version BW 3.5? I could not see any setting saying "Refresh workbook on open".

Please advice.