Creating a table of contents using the INDEX= or CONTENTS= ExcelXP tagset option might generate invalid links to the worksheets in the current workbook. This can occur if the XML file that is generated was created on an operating system other than Microsoft Windows, and an absolute path is specified as the URL. This issue can also occur if the file is moved or e-mailed, and the absolute path specified for the URL is no longer valid.

To create a relative link to the actual worksheet, use the combination of the PATH= and the FILE= ODS options with the URL= suboption. The URL=NONE suboption should be applied to both the PATH= and the FILE= ODS options. However, because of an existing problem, the URL=" " suboption with two embedded spaces must be applied to the FILE= ODS option to generate a relative path to the actual worksheet.

The sample code below illustrates this.

ods tagsets.excelxp path="c:\"(url=none) file="temp.xml"(url="  ") options(index="yes");

proc print data=sashelp.class;
run;

ods tagsets.excelxp close;

Operating System and Release Information