Showing results for 
Search instead for 
Did you mean: 

Workbook refresh

Former Member
0 Kudos


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).



Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Dear Pedro,

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

Sheets("NameOfThe Sheet").Select

Hope this helps..!


Former Member
0 Kudos

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.|]