In BEx Analyzer you could jump into another query from a query / workbook. The GoTo-Function make sense if you have one query for overview and one for detail.
When you have macros in your Analysis for Office Workbook and you remove the Crosstab of a DataSource, Analysis for Office maybe crashes. Therefore, if you need the DataSource no longer, you should remove it completely and not only the Crosstab.
In Analysis for Office 2.0, SAP has changed the name of the addin. The command is now:
Now you can continue working with the SAP Analysis commands.