Skip to Content
Jul 28, 2017 at 07:52 AM

Jump from one sheet to another sheet of same workbook in Analysis for Excel


Hi All,

I have a requirement to jump from one tab to another of same workbook in SAP Analysis for Excel.

Tab1 has a crosstab on one query and Tab2 has a crosstab on another query.Initial layout of both the sheets will have all data,On Tab1 I need to have a GOTO which will go to Tab2 , refresh the data and show only the details of the selected value in Tab1.

I searched for articles on this but couldn't get one. I found one which says that this is not possible.

Can someone please provide your thoughts on this?