https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45483#M6006 Hi:<BR /> When I use the contents= suboptions, as described here:<BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=17739䕋" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=17739䕋</A> (code example is in the middle of the post).<BR /> <BR /> I get links to each sheet. Are you using TAGSETS.EXCELXP and the contents= suboption?<BR /> <BR /> cynthia Fri, 22 Jan 2010 15:20:50 GMT Cynthia_sas 2010-01-22T15:20:50Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45482#M6005 I am creating an excel spreadsheet with a Table of Contents. I get the full URL of the location where I created the file as the link rather than just the sheet name.<BR /> Since this file is portable the links do not work. Can this be changed? Fri, 22 Jan 2010 15:12:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45482#M6005 Flip 2010-01-22T15:12:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45483#M6006 Hi:<BR /> When I use the contents= suboptions, as described here:<BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=17739䕋" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=17739䕋</A> (code example is in the middle of the post).<BR /> <BR /> I get links to each sheet. Are you using TAGSETS.EXCELXP and the contents= suboption?<BR /> <BR /> cynthia Fri, 22 Jan 2010 15:20:50 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45483#M6006 Cynthia_sas 2010-01-22T15:20:50Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45484#M6007 I got the ToC to work. The Index does not. The example helped.<BR /> <BR /> Thanks Fri, 22 Jan 2010 15:27:19 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-ToC/m-p/45484#M6007 Flip 2010-01-22T15:27:19Z