I'm generating an Excel HTML/XML worksheet. Everything works fine until I try
to have multiple <table tags and configure the Excel "Print titles"
option... when I open the Excel HTML/XML document, I get an error window
saying "Problems during load" and in the message area "Excel Name". The code
I'm using for "Print Titles" is as follows:
<x:ExcelName
<x:NamePrint_Titles</x:Name
<x:SheetIndex1</x:SheetIndex
<x:Formula=Sheet1!$1:$2</x:Formula
</x:ExcelName

And the other element is having more than one <table tag:
<table
misc tags, data...
</table
<table
....more tags, data
</table

If I remove either all the <Table</table tags except for the outer pair OR
remove the "Print Titles" code, the HTML/XML Excel document loads fine.
Neither of which are options. Anybody know what can be done to fix this
problem?

Many thanks.