ExcelXP ToC

[Flip]

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.
Since this file is portable the links do not work. Can this be changed?

[Cynthia_sas]

Hi:
When I use the contents= suboptions, as described here:
http://support.sas.com/forums/thread.jspa?messageID=17739䕋 (code example is in the middle of the post).

I get links to each sheet. Are you using TAGSETS.EXCELXP and the contents= suboption?

cynthia

[Flip]

I got the ToC to work. The Index does not. The example helped.

Thanks