Peter:
If you use the CONTENTS=yes suboption with ExcelXP, you can create a TOC with links that WILL click down into the other worksheets. And, in the program below, I have created links in the footnote to navigate from page to page. Then on sheet One, if you click on any name, it will take you to sheet 4.
With PROC REPORT, you could further customize the link, but I already had this code that just showed that the link worked. The key, when using LINK= or URL=, with ExcelXP is to use a relative name that starts with the Workbook name and to let the tagset template build everything else.
cynthia
[pre]
ods tagsets.excelxp file='all_three.xls' style=sasweb
options(contents='yes' sheet_name='One'
embedded_footnotes='yes');
ods proclabel 'Top Node 1';
proc print data=sashelp.class(obs=3) contents='One: Class';
var name / style(data)={url="all_three.xls#'Four'!A1"};
footnote link="all_three.xls#'Two'!A1" 'Go to Two';
run;
ods proclabel 'Top Node 2';
ods tagsets.excelxp options(sheet_name='Two');
proc print data=sashelp.shoes(obs=3) contents='Two: Shoes';
footnote link="all_three.xls#'Three'!A1" 'Go to Three';
run;
ods proclabel 'Top Node 3';
ods tagsets.excelxp options(sheet_name='Three');
proc print data=sashelp.prdsale(obs=3) contents='Three: PrdSale';
footnote link="all_three.xls#'One'!A1" 'Go to One';
run;
ods proclabel 'Top Node 4';
ods tagsets.excelxp options(sheet_name='Four');
proc print data=sashelp.class contents='Four: More Class';
footnote link="all_three.xls#'Contents'!A1" 'Go to Contents';
run;
ods tagsets.excelxp close;
[/pre]
