Print_Titles and mutiple <table> tags: problems during load

G

Guest

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:Name>Print_Titles</x:Name>
<x:SheetIndex>1</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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Script: <x:Name>Auto_Close</x:Name> causes errors 1
"Problems during load" 1
HTML Import Error ExcelName 0
HTML/XML format for Excel 2000. Multiple sheets in single HTML file 0
problems during load - smart tag 0
Problems During Load (XML file Open) 0
Excel question: "Problems during load" -> Table 1
Can I print a portion of a page? 2

Top