Workbook refresh

[Former Member]

Hi,

Does anybody know how set one specific sheet as active after refreshing a workbook with multiple sheets (in my case 5 sheets with 5 diferent queries).

Thanks,

Pedro

[former_member213877]

Dear Pedro,

Through VBA, you can include the below code at the end of the Refresh code:

Sheets("NameOfThe Sheet").Select

Hope this helps..!

-Pradnya

[Former Member]

Hi Pedro.

If you want workbook to always go to a specific sheet, no matter what sheet you where on when you hit refresh, there is no standard setting. Maybe some VBA can do it for you, as you "basically" just want to change the sheet? (I couldn't write it myself...)

If you want the workbook to open and refresh on a particular sheet you can do it by navigating to the sheet and then saving the workbook. For BI 7, you can control the refresh behaviour of the dataproviders. See [Configuring Dataproviders.|http://help.sap.com/saphelp_nw70/helpdata/en/62/390ea989bd40ffb01b2860a8cff183/frameset.htm]

Regards

Jacob